m2u-upass-ws / test / resources / db-scripts / m2u-upass-ci-oracle.sql @ 121:ca4e64425e8c
History | View | Annotate | Download (75.8 KB)
1 |
|
---|---|
2 |
DROP TABLE "M2U_UPASS_CI"."SMS_TABLE" cascade constraints; |
3 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" cascade constraints; |
4 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" cascade constraints; |
5 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_CONFIG_CHANGE" cascade constraints; |
6 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" cascade constraints; |
7 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_TAC" cascade constraints; |
8 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP" cascade constraints; |
9 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_USER" cascade constraints; |
10 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" cascade constraints; |
11 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_USERMAS_BACKUP" cascade constraints; |
12 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_USER_BACKUP" cascade constraints; |
13 |
DROP TABLE "M2U_UPASS_CI"."TB_AM_VASCO" cascade constraints; |
14 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_ACTION" cascade constraints; |
15 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" cascade constraints; |
16 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_CONFIG" cascade constraints; |
17 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_GROUP" cascade constraints; |
18 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" cascade constraints; |
19 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_ACTION" cascade constraints; |
20 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" cascade constraints; |
21 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" cascade constraints; |
22 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_ROLE" cascade constraints; |
23 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" cascade constraints; |
24 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE_BACKUP" cascade constraints; |
25 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY" cascade constraints; |
26 |
DROP TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY_BACKUP" cascade constraints; |
27 |
DROP TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" cascade constraints; |
28 |
DROP TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" cascade constraints; |
29 |
DROP TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" cascade constraints; |
30 |
DROP TABLE "M2U_UPASS_CI"."IB_USER" cascade constraints; |
31 |
DROP TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" cascade constraints; |
32 |
|
33 |
DROP TABLE "M2U_UPASS_CI"."M2U_USER" cascade constraints; |
34 |
DROP TABLE "M2U_UPASS_CI"."TICKETING_USER" cascade constraints; |
35 |
DROP TABLE "M2U_UPASS_CI"."IBCC_PUBLIC_USER" cascade constraints; |
36 |
DROP TABLE "M2U_UPASS_CI"."STOCK_USER" cascade constraints; |
37 |
DROP TABLE "M2U_UPASS_CI"."IM2U_USER" cascade constraints; |
38 |
DROP TABLE "M2U_UPASS_CI"."CLIENT_APP" cascade constraints; |
39 |
DROP TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" cascade constraints; |
40 |
|
41 |
DROP SEQUENCE "M2U_UPASS_CI"."IB_SEQ_TRNX"; |
42 |
DROP SEQUENCE "M2U_UPASS_CI"."IB_SEQ_SESS"; |
43 |
DROP SEQUENCE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML_OID_SEQ"; |
44 |
DROP SEQUENCE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG_LOG_ID_SEQ"; |
45 |
DROP SEQUENCE "M2U_UPASS_CI"."ADMIN_GROUP_GROUP_ID_SEQ"; |
46 |
DROP SEQUENCE "M2U_UPASS_CI"."ADMIN_USER_PROFILE_BACKUP__SEQ"; |
47 |
DROP SEQUENCE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_OID_SEQ"; |
48 |
DROP SEQUENCE "M2U_UPASS_CI"."IB_CONTENT_TYPE_OID_SEQ"; |
49 |
DROP SEQUENCE "M2U_UPASS_CI"."IB_USER_USER_ID_SEQ"; |
50 |
DROP SEQUENCE "M2U_UPASS_CI"."SEQ_USER_ID_SEQ_VALUE_SEQ"; |
51 |
DROP SEQUENCE "M2U_UPASS_CI"."SMS_TABLE_OID_SEQ"; |
52 |
DROP SEQUENCE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP_OID_SEQ"; |
53 |
DROP SEQUENCE "M2U_UPASS_CI"."TB_AM_USER_BACKUP_OID_SEQ"; |
54 |
|
55 |
--------------------------------------------------------
|
56 |
-- DDL for Sequence IB_SEQ_TRNX
|
57 |
--------------------------------------------------------
|
58 |
|
59 |
CREATE SEQUENCE "M2U_UPASS_CI"."IB_SEQ_TRNX" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; |
60 |
|
61 |
--------------------------------------------------------
|
62 |
-- DDL for Sequence IB_SEQ_SESS
|
63 |
--------------------------------------------------------
|
64 |
|
65 |
CREATE SEQUENCE "M2U_UPASS_CI"."IB_SEQ_SESS" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1 CACHE 20 NOORDER NOCYCLE ; |
66 |
|
67 |
--------------------------------------------------------
|
68 |
-- DDL for Sequence SEQ_USER_ID_SEQ_VALUE_SEQ
|
69 |
--------------------------------------------------------
|
70 |
|
71 |
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 ; |
72 |
--------------------------------------------------------
|
73 |
-- DDL for Sequence SMS_TABLE_OID_SEQ
|
74 |
--------------------------------------------------------
|
75 |
|
76 |
CREATE SEQUENCE "M2U_UPASS_CI"."SMS_TABLE_OID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 3400 CACHE 20 NOORDER NOCYCLE ; |
77 |
--------------------------------------------------------
|
78 |
-- DDL for Sequence TB_AM_TAC_BACKUP_OID_SEQ
|
79 |
--------------------------------------------------------
|
80 |
|
81 |
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 ; |
82 |
--------------------------------------------------------
|
83 |
-- DDL for Sequence TB_AM_USER_BACKUP_OID_SEQ
|
84 |
--------------------------------------------------------
|
85 |
|
86 |
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 ; |
87 |
--------------------------------------------------------
|
88 |
-- DDL for Sequence ADMIN_AUDIT_LOG_LOG_ID_SEQ
|
89 |
--------------------------------------------------------
|
90 |
|
91 |
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 ; |
92 |
--------------------------------------------------------
|
93 |
-- DDL for Sequence ADMIN_GROUP_GROUP_ID_SEQ
|
94 |
--------------------------------------------------------
|
95 |
|
96 |
CREATE SEQUENCE "M2U_UPASS_CI"."ADMIN_GROUP_GROUP_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 660 CACHE 20 NOORDER NOCYCLE ; |
97 |
--------------------------------------------------------
|
98 |
-- DDL for Sequence ADMIN_USER_PROFILE_BACKUP__SEQ
|
99 |
--------------------------------------------------------
|
100 |
|
101 |
CREATE SEQUENCE "M2U_UPASS_CI"."ADMIN_USER_PROFILE_BACKUP__SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 16 CACHE 20 NOORDER NOCYCLE ; |
102 |
--------------------------------------------------------
|
103 |
-- DDL for Sequence IB_CONTENT_CATEGORY_OID_SEQ
|
104 |
--------------------------------------------------------
|
105 |
|
106 |
CREATE SEQUENCE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_OID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 600 CACHE 20 NOORDER NOCYCLE ; |
107 |
--------------------------------------------------------
|
108 |
-- DDL for Sequence IB_CONTENT_TYPE_OID_SEQ
|
109 |
--------------------------------------------------------
|
110 |
|
111 |
CREATE SEQUENCE "M2U_UPASS_CI"."IB_CONTENT_TYPE_OID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 17 CACHE 20 NOORDER NOCYCLE ; |
112 |
--------------------------------------------------------
|
113 |
-- DDL for Sequence IB_USER_USER_ID_SEQ
|
114 |
--------------------------------------------------------
|
115 |
|
116 |
CREATE SEQUENCE "M2U_UPASS_CI"."IB_USER_USER_ID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 1010 CACHE 20 NOORDER NOCYCLE ; |
117 |
|
118 |
--------------------------------------------------------
|
119 |
-- DDL for Sequence IB_CONTENT_CATEGORY_ML_OID_SEQ
|
120 |
--------------------------------------------------------
|
121 |
|
122 |
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 ; |
123 |
|
124 |
--------------------------------------------------------
|
125 |
-- DDL for Table CLIENT_APP
|
126 |
--------------------------------------------------------
|
127 |
|
128 |
CREATE TABLE "M2U_UPASS_CI"."CLIENT_APP" ( |
129 |
"APP_ID" NUMBER(10,0) PRIMARY KEY, |
130 |
"APP_NAME" VARCHAR2(100 CHAR) |
131 |
); |
132 |
|
133 |
--------------------------------------------------------
|
134 |
-- Constraints for Table CLIENT_APP
|
135 |
--------------------------------------------------------
|
136 |
|
137 |
ALTER TABLE "M2U_UPASS_CI"."CLIENT_APP" MODIFY ("APP_ID" NOT NULL ENABLE); |
138 |
ALTER TABLE "M2U_UPASS_CI"."CLIENT_APP" MODIFY ("APP_NAME" NOT NULL ENABLE); |
139 |
|
140 |
--------------------------------------------------------
|
141 |
-- DDL for Table USER_APP_ACCESS
|
142 |
--------------------------------------------------------
|
143 |
|
144 |
CREATE TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" ( |
145 |
"USER_ID" NUMBER(10,0) , |
146 |
"APP_ID" NUMBER(10,0), |
147 |
"ACCESS_TYPE" CHAR(1 CHAR), |
148 |
"REGISTRATION_TIME" TIMESTAMP, |
149 |
CONSTRAINT PK_USER_APP_ACCESS PRIMARY KEY ( USER_ID , APP_ID ) |
150 |
); |
151 |
create index M2U_UPASS_CI.IDX_USER_APP_ACCESS_USER_ID on M2U_UPASS_CI.USER_APP_ACCESS("USER_ID"); |
152 |
|
153 |
--------------------------------------------------------
|
154 |
-- Constraints for Table USER_APP_ACCESS
|
155 |
--------------------------------------------------------
|
156 |
|
157 |
ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("USER_ID" NOT NULL ENABLE); |
158 |
ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("APP_ID" NOT NULL ENABLE); |
159 |
ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("ACCESS_TYPE" NOT NULL ENABLE); |
160 |
ALTER TABLE "M2U_UPASS_CI"."USER_APP_ACCESS" MODIFY ("REGISTRATION_TIME" NOT NULL ENABLE); |
161 |
|
162 |
--------------------------------------------------------
|
163 |
-- DDL for Table M2U_USER
|
164 |
--------------------------------------------------------
|
165 |
|
166 |
CREATE TABLE "M2U_UPASS_CI"."M2U_USER" ( |
167 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
168 |
"IBPAN" VARCHAR2(30 CHAR), |
169 |
"IBPAN2" VARCHAR2(30 CHAR) |
170 |
); |
171 |
|
172 |
--------------------------------------------------------
|
173 |
-- DDL for Table TICKETING_USER
|
174 |
--------------------------------------------------------
|
175 |
|
176 |
CREATE TABLE "M2U_UPASS_CI"."TICKETING_USER" ( |
177 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
178 |
"FULL_NAME" VARCHAR2(200 CHAR), |
179 |
"FIRST_NAME" VARCHAR2(200 CHAR), |
180 |
"LAST_NAME" VARCHAR2(200 CHAR), |
181 |
"PAYEE_CODE" VARCHAR2(20 CHAR) |
182 |
); |
183 |
|
184 |
--------------------------------------------------------
|
185 |
-- DDL for Table IBCC_PUBLIC_USER
|
186 |
--------------------------------------------------------
|
187 |
|
188 |
CREATE TABLE "M2U_UPASS_CI"."IBCC_PUBLIC_USER" ( |
189 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
190 |
"PAN_CC" VARCHAR2(20 CHAR) |
191 |
); |
192 |
|
193 |
--------------------------------------------------------
|
194 |
-- DDL for Table STOCK_USER
|
195 |
--------------------------------------------------------
|
196 |
|
197 |
CREATE TABLE "M2U_UPASS_CI"."STOCK_USER" ( |
198 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
199 |
"HIGH_NET_WORTH_ATTR" CHAR(1 CHAR), |
200 |
"CUST_TYPE" NUMBER(10,0), |
201 |
"ID_NO" VARCHAR2(20 CHAR), |
202 |
"ACTIVE_ATTR" CHAR(1 CHAR), |
203 |
"ST_ACCOUNT_NO" VARCHAR2(20 CHAR), |
204 |
"PAL_ACCOUNT_NO" VARCHAR2(20 CHAR) |
205 |
); |
206 |
|
207 |
--------------------------------------------------------
|
208 |
-- DDL for Table IM2U_USER
|
209 |
--------------------------------------------------------
|
210 |
|
211 |
CREATE TABLE "M2U_UPASS_CI"."IM2U_USER" ( |
212 |
"USER_ID" NUMBER(10,0) PRIMARY KEY, |
213 |
"WS_FLAG" CHAR(1 CHAR), |
214 |
"WS_IDENT_CODE" VARCHAR2(100 CHAR), |
215 |
"WS_MY_SG_ID" VARCHAR2(20 CHAR), |
216 |
"WS_REG_TIMESTAMP" TIMESTAMP |
217 |
); |
218 |
|
219 |
|
220 |
--------------------------------------------------------
|
221 |
-- DDL for Table SMS_TABLE
|
222 |
--------------------------------------------------------
|
223 |
|
224 |
CREATE TABLE "M2U_UPASS_CI"."SMS_TABLE" |
225 |
( "OID" NUMBER(38,2), |
226 |
"SMS_CREATESTAMP" TIMESTAMP, |
227 |
"SMS_IBREF_NO" VARCHAR2(20 CHAR), |
228 |
"SMS_IC_NO" VARCHAR2(30 CHAR), |
229 |
"SMS_CUST_NAME" VARCHAR2(40 CHAR), |
230 |
"SMS_HP_NO" VARCHAR2(30 CHAR), |
231 |
"SMS_MESSAGE" VARCHAR2(512 CHAR), |
232 |
"SMS_SERVICE" VARCHAR2(64 CHAR), |
233 |
"SMS_STATUS" VARCHAR2(4 CHAR), |
234 |
"CREATION_DATE" TIMESTAMP, |
235 |
"SMS_GUID" VARCHAR2(45 CHAR), |
236 |
"SMS_SDDATESTAMP" TIMESTAMP, |
237 |
"SMS_RCDATESTAMP" TIMESTAMP, |
238 |
"SMS_CHECK" VARCHAR2(2 CHAR), |
239 |
"SMS_PRIORITY" VARCHAR2(2 CHAR), |
240 |
"SMS_TYPE" VARCHAR2(64 CHAR), |
241 |
"STATUS" VARCHAR2(64 CHAR), |
242 |
"REFERENCE" VARCHAR2(50 CHAR), |
243 |
"REMOTE_IP" VARCHAR2(64 CHAR), |
244 |
"OTHER1" VARCHAR2(50 CHAR), |
245 |
"OTHER2" VARCHAR2(50 CHAR), |
246 |
"AMOUNT" NUMBER(38,2), |
247 |
"IB_SERVICE" VARCHAR2(50 CHAR) |
248 |
) ; |
249 |
--------------------------------------------------------
|
250 |
-- DDL for Table TB_AM_APPSERV
|
251 |
--------------------------------------------------------
|
252 |
|
253 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" |
254 |
( |
255 |
"A_USER_ID" NUMBER(10,0), |
256 |
"A_APP_SERV_ID" VARCHAR2(10 CHAR), |
257 |
"A_APP_SERV_ACCESS1" VARCHAR2(20 CHAR), |
258 |
"A_APP_SERV_ACCESS2" VARCHAR2(20 CHAR), |
259 |
"A_APP_SERV_AUTH_LIST" VARCHAR2(20 CHAR) , |
260 |
CONSTRAINT PK_TB_AM_APPSERV PRIMARY KEY ( A_USER_ID , A_APP_SERV_ID ) |
261 |
); |
262 |
--------------------------------------------------------
|
263 |
-- DDL for Table TB_AM_CONFIG
|
264 |
--------------------------------------------------------
|
265 |
|
266 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" |
267 |
( |
268 |
"CONFIG_NAME" VARCHAR2(64 CHAR), |
269 |
"CONFIG_VALUE" VARCHAR2(128 CHAR), |
270 |
"CONFIG_DESCRIPTION" VARCHAR2(256 CHAR), |
271 |
"APPLICATION_ID" NUMBER(10,0), |
272 |
"MK_PENDING" NUMBER(38,2), |
273 |
CONSTRAINT PK_TB_AM_CONFIG PRIMARY KEY ( CONFIG_NAME , APPLICATION_ID ) |
274 |
) ; |
275 |
--------------------------------------------------------
|
276 |
-- DDL for Table TB_AM_CONFIG_CHANGE
|
277 |
--------------------------------------------------------
|
278 |
|
279 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_CONFIG_CHANGE" |
280 |
( "CONFIG_UPDATE" NUMBER(10,0) PRIMARY KEY |
281 |
) ; |
282 |
--------------------------------------------------------
|
283 |
-- DDL for Table TB_AM_GEMALTO
|
284 |
--------------------------------------------------------
|
285 |
|
286 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" |
287 |
( "G_SERIAL_NO" VARCHAR2(22 CHAR) PRIMARY KEY, |
288 |
"G_USER_ID" NUMBER(10,0), |
289 |
"G_DP_MODEL" VARCHAR2(5 CHAR), |
290 |
"G_DP_AUTH_MODE" VARCHAR2(2 CHAR), |
291 |
"G_DP_CIPHERTEXT" BLOB, |
292 |
"G_BAK_CIPHERTEXT" BLOB, |
293 |
"G_DP_ASSIGNED" NUMBER(10,0), |
294 |
"G_DATE_ASSIGNED" TIMESTAMP, |
295 |
"G_DATE_FIRST_USED" TIMESTAMP, |
296 |
"G_DATE_LAST_USED" TIMESTAMP, |
297 |
"G_USE_COUNT" NUMBER(10,0), |
298 |
"G_ERROR_COUNT" NUMBER(10,0), |
299 |
"G_DP_STATE" NUMBER(10,0), |
300 |
"G_BATCH_NO" VARCHAR2(8 CHAR) |
301 |
) ; |
302 |
--------------------------------------------------------
|
303 |
-- DDL for Table TB_AM_TAC
|
304 |
--------------------------------------------------------
|
305 |
|
306 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_TAC" |
307 |
( "T_USER_ID" NUMBER(10,0) PRIMARY KEY, |
308 |
"T_TAC_CIPHERTEXT" VARCHAR2(128 CHAR), |
309 |
"T_TAC_STATE" NUMBER(10,0), |
310 |
"T_DATE_GENERATED" TIMESTAMP, |
311 |
"T_DATE_FIRST_USED" TIMESTAMP, |
312 |
"T_DATE_LAST_USED" TIMESTAMP, |
313 |
"T_USE_COUNT" NUMBER(10,0), |
314 |
"T_ERROR_COUNT" NUMBER(10,0), |
315 |
"T_SESSION_ID" VARCHAR2(32 CHAR) |
316 |
) ; |
317 |
--------------------------------------------------------
|
318 |
-- DDL for Table TB_AM_TAC_BACKUP
|
319 |
--------------------------------------------------------
|
320 |
|
321 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP" |
322 |
( "OID" NUMBER(10,0) PRIMARY KEY, |
323 |
"T_USER_ID" NUMBER(10,0), |
324 |
"T_TAC_CIPHERTEXT" VARCHAR2(64 CHAR), |
325 |
"T_TAC_STATE" NUMBER(10,0), |
326 |
"T_DATE_GENERATED" TIMESTAMP, |
327 |
"T_DATE_FIRST_USED" TIMESTAMP, |
328 |
"T_DATE_LAST_USED" CHAR(10 CHAR), |
329 |
"T_USE_COUNT" NUMBER(10,0), |
330 |
"T_ERROR_COUNT" NUMBER(10,0), |
331 |
"T_SESSION_ID" VARCHAR2(32 CHAR), |
332 |
"T_APPLICATION_ID" NUMBER(10,0) |
333 |
) ; |
334 |
--------------------------------------------------------
|
335 |
-- DDL for Table TB_AM_USER
|
336 |
--------------------------------------------------------
|
337 |
|
338 |
CREATE TABLE "M2U_UPASS_CI"."TB_AM_USER" |
339 |
( "U_USER_ID" NUMBER(10,0) PRIMARY KEY, |
340 |
"U_USER_ALIAS" VARCHAR2(50 CHAR) unique, |
341 |
"U_USER_TYPE" NUMBER(10,0), |
342 |
"U_USER_DESC" VARCHAR2(40 CHAR), |
343 |
"U_DATE_CREATED" TIMESTAMP, |
344 |
"U_DATE_LAST_USED" TIMESTAMP, |
345 |
"U_USE_COUNT" NUMBER(19,0), |
346 |
"U_DATE_LAST_ACT" TIMESTAMP, |
347 |
"U_DATE_LAST_LOCK" TIMESTAMP, |
348 |
"U_USER_STATE" NUMBER(10,0), |
349 |
"U_DATE_LOCK_FROM" TIMESTAMP, |
350 |
"U_DATE_LOCK_TO" TIMESTAMP, |
351 |
"P_PASSWD_CIPHERTEXT" VARCHAR2(64 CHAR), |
352 |
"P_PASSWD_STATE" NUMBER(10,0), |
353 |
"P_DATE_GENERATED" TIMESTAMP, |
354 |
"P_DATE_FIRST_USED" TIMESTAMP, |
355 |
"P_DATE_LAST_USED" TIMESTAMP, |
356 |
"P_USE_COUNT" NUMBER(19,0), |
357 |
"P_ERROR_COUNT" NUMBER(10,0), |
358 |
"P_EXPIRED_STATUS" NUMBER(10,0), |
359 |
"P_DATE_EXPIRED" TIMESTAMP, |
360 |
"P_PASSWD_HIST" VARCHAR(1024), |
361 |
"U_APPLICATION_ID" NUMBER(10,0) |
362 |
) ; |
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(1024 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) PRIMARY KEY, |
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','0', 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','0', 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','0', 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','0', EMPTY_CLOB(),0,0); |
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(),1,1); |
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(),2,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(),3,0); |
783 |
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); |
784 |
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); |
785 |
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); |
786 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('NOTIF_ALERT','0', EMPTY_CLOB(),0,0); |
787 |
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); |
788 |
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); |
789 |
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); |
790 |
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); |
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(),3,0); |
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(),1,1); |
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(),2,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(),4,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(),5,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(),0,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(),3,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(),4,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(),5,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(),1,1); |
801 |
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); |
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(),0,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(),3,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(),4,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(),5,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(),1,1); |
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(),2,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(),0,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(),3,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(),4,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(),5,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(),1,1); |
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(),2,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(),0,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(),3,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(),4,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(),5,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(),1,1); |
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(),2,0); |
820 |
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); |
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(),3,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(),4,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(),5,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(),1,1); |
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(),2,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(),0,0); |
827 |
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(),3,0); |
828 |
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(),4,0); |
829 |
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(),5,0); |
830 |
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(),1,1); |
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(),2,0); |
832 |
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); |
833 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','6', EMPTY_CLOB(),3,0); |
834 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','6', EMPTY_CLOB(),4,0); |
835 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','6', EMPTY_CLOB(),5,0); |
836 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','6', EMPTY_CLOB(),1,1); |
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(),2,0); |
838 |
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); |
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(),3,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(),4,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(),5,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(),1,1); |
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(),2,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(),0,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(),3,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(),4,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(),5,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(),1,1); |
849 |
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); |
850 |
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); |
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(),3,0); |
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(),1,1); |
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(),2,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(),4,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(),5,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(),0,0); |
857 |
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); |
858 |
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); |
859 |
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); |
860 |
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); |
861 |
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); |
862 |
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); |
863 |
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); |
864 |
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); |
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(),0,0); |
866 |
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); |
867 |
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); |
868 |
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); |
869 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','180', EMPTY_CLOB(),3,0); |
870 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','180', EMPTY_CLOB(),1,1); |
871 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','180', EMPTY_CLOB(),2,0); |
872 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','180', EMPTY_CLOB(),0,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(),3,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(),4,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(),5,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(),1,1); |
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(),2,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(),0,0); |
879 |
|
880 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG_CHANGE (CONFIG_UPDATE) values (1); |
881 |
Insert into M2U_UPASS_CI.TB_AM_CONFIG_CHANGE (CONFIG_UPDATE) values (2); |
882 |
|
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 (1,'root',0,'Root ID',SYSDATE,SYSDATE,19,null,null,0,null,null,'1408A0F64A991CE378292A7EFB4B7B84DF7F9D98114C8E6F63C4758F062F989D',0,SYSDATE,SYSDATE,SYSDATE,19,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 (2,'administrator',1,'Admin',SYSDATE,SYSDATE,3256,null,SYSDATE,0,SYSDATE,SYSDATE,'64535FE6B9714612F18632CD33A2C2864DAA4EE1D06284FCA66D7DC1DD4689F8',0,SYSDATE,SYSDATE,SYSDATE,0,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',SYSDATE,null,0,null,null,0,null,null,'31FC33E8DDFFE672C0975A8D3C9BF8AFE8F0DA511E70452514D3491190CA0E4F',0,SYSDATE,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',SYSDATE,null,0,null,null,0,null,null,'9382596D75FDF7DB48FA6BD0F3EB41587331F4340F5A3656D2F886406F290022',0,SYSDATE,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',SYSDATE,null,0,null,null,0,null,null,'BA2D69FB001B6A21FE5005528E8CFEEEA6C939D47E0CD383DD0D61295848FD89',0,SYSDATE,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',SYSDATE,null,0,null,null,0,null,null,'98C3D7E8CD74B22374703C31D182E56355B6830D5B648E8202883565881A88F6',0,SYSDATE,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',SYSDATE,null,0,null,null,0,null,null,'19264C925BB223D518D9284441353949FDA028FAABA3153DBA9752C3C89A7C28',0,SYSDATE,null,null,0,0,1,null,5); |
890 |
|
891 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('root',1); |
892 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('administrator',2); |
893 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser1',100); |
894 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser2',101); |
895 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser3',102); |
896 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser4',103); |
897 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser5',104); |
898 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser6',105); |
899 |
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser7',106); |
900 |
|
901 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (1021,'Unlock Customer',0,0); |
902 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (1023,'Activate Customer',0,0); |
903 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3002,'Edit USS Navigation',1,0); |
904 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3011,'Create USS Group',1,0); |
905 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3012,'Edit USS Group',1,0); |
906 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3013,'Delete USS Group',1,0); |
907 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3021,'Create USS User',1,0); |
908 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3022,'Edit USS User',1,0); |
909 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3023,'Delete USS User',1,0); |
910 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3024,'Suspend USS User',1,0); |
911 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3025,'Activate USS User',1,0); |
912 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3026,'Unlock USS User',1,0); |
913 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3027,'Reset Password for USS User',1,0); |
914 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3031,'Edit UPASS Configs',1,0); |
915 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (8001,'Create Application Admin',1,0); |
916 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (8002,'Edit Application Admin',1,0); |
917 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (8003,'Delete Application Admin',1,0); |
918 |
Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (8004,'Reset Password for Application Admin',1,0); |
919 |
|
920 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (1,1021); |
921 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (1,1023); |
922 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3021); |
923 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3022); |
924 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3023); |
925 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3024); |
926 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3025); |
927 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3026); |
928 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3027); |
929 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (6,3002); |
930 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (7,3011); |
931 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (7,3012); |
932 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (7,3013); |
933 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (35,3031); |
934 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8001); |
935 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8002); |
936 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8003); |
937 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8004); |
938 |
|
939 |
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 (2,1,1,'Administrator',null,'mail@mail.com',null,null,null,null,0,12,SYSDATE,null,1,0,null,null,null); |
940 |
|
941 |
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,SYSDATE,SYSDATE,1,9,'1',0); |
942 |
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,SYSDATE,SYSDATE,1,0,'1',0); |
943 |
|
944 |
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,SYSDATE,SYSDATE,1,'IBAM',0); |
945 |
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,SYSDATE,SYSDATE,1,'IBAM',0); |
946 |
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,SYSDATE,SYSDATE,1,'IBAM',0); |
947 |
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,SYSDATE,SYSDATE,1,'IBAM',0); |
948 |
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,SYSDATE,SYSDATE,1,'IBAM',0); |
949 |
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,SYSDATE,SYSDATE,1,'IBAM',0); |
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 (9,19,'Change Your Password','Change Password','1','0','SSSSCPWD',7,'/ss102/changePassword.do',6,12,SYSDATE,SYSDATE,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 (35,19,'Upass USS Maintenance','Settings','1','0','SSSSSETT',8,'/ss221/settings.do',1,12,SYSDATE,SYSDATE,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 (36,19,'Application Admin Maintenance','To Maintain Application Admin','1','0','SSSSAUM',9,'/ss223/appUserEnquiryMain.do',1,12,SYSDATE,SYSDATE,1,'IBAM',0); |
953 |
|
954 |
|
955 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (1,1,0,0,'SSSSUENQ'); |
956 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (3,1,0,0,'SSSSAENQ'); |
957 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (6,1,0,0,'SSSSNAVI'); |
958 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (7,1,0,0,'SSSSAGRP'); |
959 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (8,1,0,0,'SSSSALOG'); |
960 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (9,1,0,0,'SSSSCPWD'); |
961 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (19,1,0,0,'ADMIN'); |
962 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (35,1,0,0,'SSSSSETT'); |
963 |
Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (36,1,0,0,'SSSSAUM'); |
964 |
|
965 |
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,SYSDATE,null); |
966 |
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,SYSDATE,null); |
967 |
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,SYSDATE,null); |
968 |
|
969 |
Insert into M2U_UPASS_CI.IB_USER (USER_ID,ACCOUNT_ID,USER_ALIAS,PASSWORD,USER_STATE,MODIF_TIME,CREATION_DATE) values (2,0,'administrator',null,0,SYSDATE,SYSDATE); |
970 |
|
971 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (1, 'M2U Retail Internet Banking'); |
972 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (2, 'Maybank Online Stock'); |
973 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (3, 'Maybank Online Ticketing'); |
974 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (4, 'Maybank CCPP'); |
975 |
Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (5, 'M2U Singapore Integration'); |
976 |
|
977 |
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); |
978 |
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); |
979 |
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); |
980 |
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); |
981 |
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); |
982 |
|
983 |
|
984 |
--------------------------------------------------------
|
985 |
-- Constraints for Table TB_AM_TAC
|
986 |
--------------------------------------------------------
|
987 |
|
988 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_ERROR_COUNT" NOT NULL ENABLE); |
989 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_USE_COUNT" NOT NULL ENABLE); |
990 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_TAC_STATE" NOT NULL ENABLE); |
991 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_USER_ID" NOT NULL ENABLE); |
992 |
--------------------------------------------------------
|
993 |
-- Constraints for Table TB_AM_GEMALTO
|
994 |
--------------------------------------------------------
|
995 |
|
996 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_DP_STATE" NOT NULL ENABLE); |
997 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_ERROR_COUNT" NOT NULL ENABLE); |
998 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_USE_COUNT" NOT NULL ENABLE); |
999 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_DP_ASSIGNED" NOT NULL ENABLE); |
1000 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_BAK_CIPHERTEXT" NOT NULL ENABLE); |
1001 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_DP_CIPHERTEXT" NOT NULL ENABLE); |
1002 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_USER_ID" NOT NULL ENABLE); |
1003 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_SERIAL_NO" NOT NULL ENABLE); |
1004 |
--------------------------------------------------------
|
1005 |
-- Constraints for Table TB_AM_USERMAS
|
1006 |
--------------------------------------------------------
|
1007 |
|
1008 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" MODIFY ("M_USER_ID" NOT NULL ENABLE); |
1009 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" MODIFY ("M_USER_ALIAS" NOT NULL ENABLE); |
1010 |
--------------------------------------------------------
|
1011 |
-- Constraints for Table TB_AM_USER_BACKUP
|
1012 |
--------------------------------------------------------
|
1013 |
|
1014 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
1015 |
--------------------------------------------------------
|
1016 |
-- Constraints for Table TB_AM_APPSERV
|
1017 |
--------------------------------------------------------
|
1018 |
|
1019 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_APP_SERV_ACCESS2" NOT NULL ENABLE); |
1020 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_APP_SERV_ACCESS1" NOT NULL ENABLE); |
1021 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_APP_SERV_ID" NOT NULL ENABLE); |
1022 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_USER_ID" NOT NULL ENABLE); |
1023 |
--------------------------------------------------------
|
1024 |
-- Constraints for Table TB_AM_CONFIG_CHANGE
|
1025 |
--------------------------------------------------------
|
1026 |
|
1027 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG_CHANGE" MODIFY ("CONFIG_UPDATE" NOT NULL ENABLE); |
1028 |
--------------------------------------------------------
|
1029 |
-- Constraints for Table TB_AM_TAC_BACKUP
|
1030 |
--------------------------------------------------------
|
1031 |
|
1032 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
1033 |
--------------------------------------------------------
|
1034 |
-- Constraints for Table SMS_TABLE
|
1035 |
--------------------------------------------------------
|
1036 |
|
1037 |
ALTER TABLE "M2U_UPASS_CI"."SMS_TABLE" MODIFY ("OID" NOT NULL ENABLE); |
1038 |
--------------------------------------------------------
|
1039 |
-- Constraints for Table TB_AM_VASCO
|
1040 |
--------------------------------------------------------
|
1041 |
|
1042 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_DP_STATE" NOT NULL ENABLE); |
1043 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_ERROR_COUNT" NOT NULL ENABLE); |
1044 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_USE_COUNT" NOT NULL ENABLE); |
1045 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_DP_ASSIGNED" NOT NULL ENABLE); |
1046 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_BAK_CIPHERTEXT" NOT NULL ENABLE); |
1047 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_DP_CIPHERTEXT" NOT NULL ENABLE); |
1048 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_USER_ID" NOT NULL ENABLE); |
1049 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_SERIAL_NO" NOT NULL ENABLE); |
1050 |
--------------------------------------------------------
|
1051 |
-- Constraints for Table TB_AM_CONFIG
|
1052 |
--------------------------------------------------------
|
1053 |
|
1054 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
1055 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" MODIFY ("APPLICATION_ID" NOT NULL ENABLE); |
1056 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" MODIFY ("CONFIG_NAME" NOT NULL ENABLE); |
1057 |
--------------------------------------------------------
|
1058 |
-- Constraints for Table TB_AM_USERMAS_BACKUP
|
1059 |
--------------------------------------------------------
|
1060 |
|
1061 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS_BACKUP" MODIFY ("M_USER_ALIAS" NOT NULL ENABLE); |
1062 |
--------------------------------------------------------
|
1063 |
-- Constraints for Table TB_AM_USER
|
1064 |
--------------------------------------------------------
|
1065 |
|
1066 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_EXPIRED_STATUS" NOT NULL ENABLE); |
1067 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_ERROR_COUNT" NOT NULL ENABLE); |
1068 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_USE_COUNT" NOT NULL ENABLE); |
1069 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_DATE_GENERATED" NOT NULL ENABLE); |
1070 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_PASSWD_STATE" NOT NULL ENABLE); |
1071 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_STATE" NOT NULL ENABLE); |
1072 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USE_COUNT" NOT NULL ENABLE); |
1073 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_DATE_CREATED" NOT NULL ENABLE); |
1074 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_TYPE" NOT NULL ENABLE); |
1075 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_ALIAS" NOT NULL ENABLE); |
1076 |
ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_ID" NOT NULL ENABLE); |
1077 |
|
1078 |
--------------------------------------------------------
|
1079 |
-- Constraints for Table ADMIN_ACTION
|
1080 |
--------------------------------------------------------
|
1081 |
|
1082 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ACTION" MODIFY ("APPROVABLE" NOT NULL ENABLE); |
1083 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ACTION" MODIFY ("ACTION" NOT NULL ENABLE); |
1084 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ACTION" MODIFY ("ACTION_ID" NOT NULL ENABLE); |
1085 |
--------------------------------------------------------
|
1086 |
-- Constraints for Table ADMIN_AUDIT_LOG
|
1087 |
--------------------------------------------------------
|
1088 |
|
1089 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("LOG_CREATION_DATE" NOT NULL ENABLE); |
1090 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("LOG_DESCRIPTION" NOT NULL ENABLE); |
1091 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("AUDIT_CATEGORY_ID" NOT NULL ENABLE); |
1092 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("LOG_ID" NOT NULL ENABLE); |
1093 |
--------------------------------------------------------
|
1094 |
-- Constraints for Table ADMIN_GROUP
|
1095 |
--------------------------------------------------------
|
1096 |
|
1097 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_LVL" NOT NULL ENABLE); |
1098 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_CREATION_DATE" NOT NULL ENABLE); |
1099 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_NAME" NOT NULL ENABLE); |
1100 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
1101 |
--------------------------------------------------------
|
1102 |
-- Constraints for Table ADMIN_NAVIGATION
|
1103 |
--------------------------------------------------------
|
1104 |
|
1105 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_CREATION_DATE" NOT NULL ENABLE); |
1106 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_CODE" NOT NULL ENABLE); |
1107 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_NAME" NOT NULL ENABLE); |
1108 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_ID" NOT NULL ENABLE); |
1109 |
--------------------------------------------------------
|
1110 |
-- Constraints for Table ADMIN_NAVIGATION_ACTION
|
1111 |
--------------------------------------------------------
|
1112 |
|
1113 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_ACTION" MODIFY ("ACTION_ID" NOT NULL ENABLE); |
1114 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_ACTION" MODIFY ("NAVIGATION_ID" NOT NULL ENABLE); |
1115 |
--------------------------------------------------------
|
1116 |
-- Constraints for Table ADMIN_NAVIGATION_GROUP
|
1117 |
--------------------------------------------------------
|
1118 |
|
1119 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("IS_VIEW" NOT NULL ENABLE); |
1120 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("IS_EDIT" NOT NULL ENABLE); |
1121 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
1122 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("NAVIGATION_ID" NOT NULL ENABLE); |
1123 |
--------------------------------------------------------
|
1124 |
-- Constraints for Table ADMIN_PERMISSION
|
1125 |
--------------------------------------------------------
|
1126 |
|
1127 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" MODIFY ("IS_APPROVER" NOT NULL ENABLE); |
1128 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" MODIFY ("ACTION_ID" NOT NULL ENABLE); |
1129 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" MODIFY ("USER_ID" NOT NULL ENABLE); |
1130 |
--------------------------------------------------------
|
1131 |
-- Constraints for Table ADMIN_ROLE
|
1132 |
--------------------------------------------------------
|
1133 |
|
1134 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ROLE" MODIFY ("ROLE_CREATION_DATE" NOT NULL ENABLE); |
1135 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ROLE" MODIFY ("ROLE_NAME" NOT NULL ENABLE); |
1136 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_ROLE" MODIFY ("ROLE_ID" NOT NULL ENABLE); |
1137 |
--------------------------------------------------------
|
1138 |
-- Constraints for Table ADMIN_USER_PROFILE
|
1139 |
--------------------------------------------------------
|
1140 |
|
1141 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
1142 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("FORCE_RESET" NOT NULL ENABLE); |
1143 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("USER_EMAIL" NOT NULL ENABLE); |
1144 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("USER_NAME" NOT NULL ENABLE); |
1145 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
1146 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("ROLE_ID" NOT NULL ENABLE); |
1147 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("USER_ID" NOT NULL ENABLE); |
1148 |
--------------------------------------------------------
|
1149 |
-- Constraints for Table ADMIN_USER_PROFILE_BACKUP
|
1150 |
--------------------------------------------------------
|
1151 |
|
1152 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
1153 |
--------------------------------------------------------
|
1154 |
-- Constraints for Table ADMIN_USER_SECURITY
|
1155 |
--------------------------------------------------------
|
1156 |
|
1157 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY" MODIFY ("USER_ID" NOT NULL ENABLE); |
1158 |
--------------------------------------------------------
|
1159 |
-- Constraints for Table ADMIN_USER_SECURITY_BACKUP
|
1160 |
--------------------------------------------------------
|
1161 |
|
1162 |
ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY_BACKUP" MODIFY ("USER_ID" NOT NULL ENABLE); |
1163 |
--------------------------------------------------------
|
1164 |
-- Constraints for Table IB_CONTENT_CATEGORY
|
1165 |
--------------------------------------------------------
|
1166 |
|
1167 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
1168 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("CONTENT_TYPE_ID" NOT NULL ENABLE); |
1169 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("CREATION_DATE" NOT NULL ENABLE); |
1170 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("OID" NOT NULL ENABLE); |
1171 |
--------------------------------------------------------
|
1172 |
-- Constraints for Table IB_CONTENT_TYPE
|
1173 |
--------------------------------------------------------
|
1174 |
|
1175 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" MODIFY ("CREATION_DATE" NOT NULL ENABLE); |
1176 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" MODIFY ("CONTENT_TYPE_CODE" NOT NULL ENABLE); |
1177 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" MODIFY ("OID" NOT NULL ENABLE); |
1178 |
--------------------------------------------------------
|
1179 |
-- Constraints for Table IB_CUST_PROFILE
|
1180 |
--------------------------------------------------------
|
1181 |
|
1182 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
1183 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("ROLE_ID" NOT NULL ENABLE); |
1184 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
1185 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("NO_FULLTIME_EMP" NOT NULL ENABLE); |
1186 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("ANNUAL_TURNOVER" NOT NULL ENABLE); |
1187 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("YEAR" NOT NULL ENABLE); |
1188 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("BRANCH_NO" NOT NULL ENABLE); |
1189 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("NO_OF_DEPENDENTS" NOT NULL ENABLE); |
1190 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("DURATION_STAY_PRE_ADD" NOT NULL ENABLE); |
1191 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("NO_OF_EMP" NOT NULL ENABLE); |
1192 |
ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("USER_ID" NOT NULL ENABLE); |
1193 |
--------------------------------------------------------
|
1194 |
-- Constraints for Table IB_USER
|
1195 |
--------------------------------------------------------
|
1196 |
|
1197 |
ALTER TABLE "M2U_UPASS_CI"."IB_USER" MODIFY ("CREATION_DATE" NOT NULL ENABLE); |
1198 |
ALTER TABLE "M2U_UPASS_CI"."IB_USER" MODIFY ("ACCOUNT_ID" NOT NULL ENABLE); |
1199 |
ALTER TABLE "M2U_UPASS_CI"."IB_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1200 |
|
1201 |
--------------------------------------------------------
|
1202 |
-- Constraints for Table IB_CONTENT_CATEGORY_ML
|
1203 |
--------------------------------------------------------
|
1204 |
|
1205 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("CONTENT_CATEGORY_ID" NOT NULL ENABLE); |
1206 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("LOCALE" NOT NULL ENABLE); |
1207 |
ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("OID" NOT NULL ENABLE); |
1208 |
|
1209 |
|
1210 |
ALTER TABLE "M2U_UPASS_CI"."M2U_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1211 |
ALTER TABLE "M2U_UPASS_CI"."TICKETING_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1212 |
ALTER TABLE "M2U_UPASS_CI"."IBCC_PUBLIC_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1213 |
ALTER TABLE "M2U_UPASS_CI"."STOCK_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
1214 |
ALTER TABLE "M2U_UPASS_CI"."IM2U_USER" MODIFY ("USER_ID" NOT NULL ENABLE) |
1215 |
|