m2u-upass-ws / test / resources / db-scripts / m2u-upass-ci-oracle.sql @ 121:ca4e64425e8c
History | View | Annotate | Download (75.8 KB)
1 | 121:ca4e64425e8c | mohd | |
---|---|---|---|
2 | 13:24e577240a06 | mohd | 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 | 48:1142dd56945e | mohd | 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 | 52:7c5432c4668e | mohd | 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 | 15:a225af95c3f1 | hadi | |
41 | 48:1142dd56945e | mohd | 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 | 13:24e577240a06 | mohd | 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 | 48:1142dd56945e | mohd | |
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 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
68 | -- DDL for Sequence SEQ_USER_ID_SEQ_VALUE_SEQ
|
||
69 | --------------------------------------------------------
|
||
70 | |||
71 | 57:66ab29696441 | mohd | 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 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
73 | -- DDL for Sequence SMS_TABLE_OID_SEQ
|
||
74 | --------------------------------------------------------
|
||
75 | |||
76 | 13:24e577240a06 | mohd | CREATE SEQUENCE "M2U_UPASS_CI"."SMS_TABLE_OID_SEQ" MINVALUE 1 MAXVALUE 999999999999999999999999 INCREMENT BY 1 START WITH 3400 CACHE 20 NOORDER NOCYCLE ; |
77 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
78 | -- DDL for Sequence TB_AM_TAC_BACKUP_OID_SEQ
|
||
79 | --------------------------------------------------------
|
||
80 | |||
81 | 13:24e577240a06 | mohd | 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 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
83 | -- DDL for Sequence TB_AM_USER_BACKUP_OID_SEQ
|
||
84 | --------------------------------------------------------
|
||
85 | |||
86 | 13:24e577240a06 | mohd | 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 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
88 | 48:1142dd56945e | mohd | -- 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 | 57:66ab29696441 | mohd | -- 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 | 88:86f6dc32ef98 | hadi | create index M2U_UPASS_CI.IDX_USER_APP_ACCESS_USER_ID on M2U_UPASS_CI.USER_APP_ACCESS("USER_ID"); |
152 | 57:66ab29696441 | mohd | |
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 | 52:7c5432c4668e | mohd | -- DDL for Table M2U_USER
|
164 | --------------------------------------------------------
|
||
165 | |||
166 | CREATE TABLE "M2U_UPASS_CI"."M2U_USER" ( |
||
167 | "USER_ID" NUMBER(10,0) PRIMARY KEY, |
||
168 | 57:66ab29696441 | mohd | "IBPAN" VARCHAR2(30 CHAR), |
169 | "IBPAN2" VARCHAR2(30 CHAR) |
||
170 | 52:7c5432c4668e | mohd | ); |
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 | 12:5440377775e9 | mohd | -- DDL for Table SMS_TABLE
|
222 | --------------------------------------------------------
|
||
223 | |||
224 | 13:24e577240a06 | mohd | CREATE TABLE "M2U_UPASS_CI"."SMS_TABLE" |
225 | 12:5440377775e9 | mohd | ( "OID" NUMBER(38,2), |
226 | 48:1142dd56945e | mohd | "SMS_CREATESTAMP" TIMESTAMP, |
227 | 12:5440377775e9 | mohd | "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 | 48:1142dd56945e | mohd | "CREATION_DATE" TIMESTAMP, |
235 | 12:5440377775e9 | mohd | "SMS_GUID" VARCHAR2(45 CHAR), |
236 | 48:1142dd56945e | mohd | "SMS_SDDATESTAMP" TIMESTAMP, |
237 | "SMS_RCDATESTAMP" TIMESTAMP, |
||
238 | 12:5440377775e9 | mohd | "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 | 13:24e577240a06 | mohd | ) ; |
249 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
250 | -- DDL for Table TB_AM_APPSERV
|
||
251 | --------------------------------------------------------
|
||
252 | |||
253 | 15:a225af95c3f1 | hadi | 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 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
263 | -- DDL for Table TB_AM_CONFIG
|
||
264 | --------------------------------------------------------
|
||
265 | |||
266 | 15:a225af95c3f1 | hadi | 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 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
276 | -- DDL for Table TB_AM_CONFIG_CHANGE
|
||
277 | --------------------------------------------------------
|
||
278 | |||
279 | 13:24e577240a06 | mohd | CREATE TABLE "M2U_UPASS_CI"."TB_AM_CONFIG_CHANGE" |
280 | 15:a225af95c3f1 | hadi | ( "CONFIG_UPDATE" NUMBER(10,0) PRIMARY KEY |
281 | 13:24e577240a06 | mohd | ) ; |
282 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
283 | -- DDL for Table TB_AM_GEMALTO
|
||
284 | --------------------------------------------------------
|
||
285 | |||
286 | 13:24e577240a06 | mohd | CREATE TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" |
287 | 15:a225af95c3f1 | hadi | ( "G_SERIAL_NO" VARCHAR2(22 CHAR) PRIMARY KEY, |
288 | 12:5440377775e9 | mohd | "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 | 48:1142dd56945e | mohd | "G_DATE_ASSIGNED" TIMESTAMP, |
295 | "G_DATE_FIRST_USED" TIMESTAMP, |
||
296 | "G_DATE_LAST_USED" TIMESTAMP, |
||
297 | 12:5440377775e9 | mohd | "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 | 13:24e577240a06 | mohd | ) ; |
302 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
303 | -- DDL for Table TB_AM_TAC
|
||
304 | --------------------------------------------------------
|
||
305 | |||
306 | 13:24e577240a06 | mohd | CREATE TABLE "M2U_UPASS_CI"."TB_AM_TAC" |
307 | 15:a225af95c3f1 | hadi | ( "T_USER_ID" NUMBER(10,0) PRIMARY KEY, |
308 | 12:5440377775e9 | mohd | "T_TAC_CIPHERTEXT" VARCHAR2(128 CHAR), |
309 | "T_TAC_STATE" NUMBER(10,0), |
||
310 | 48:1142dd56945e | mohd | "T_DATE_GENERATED" TIMESTAMP, |
311 | "T_DATE_FIRST_USED" TIMESTAMP, |
||
312 | "T_DATE_LAST_USED" TIMESTAMP, |
||
313 | 12:5440377775e9 | mohd | "T_USE_COUNT" NUMBER(10,0), |
314 | "T_ERROR_COUNT" NUMBER(10,0), |
||
315 | "T_SESSION_ID" VARCHAR2(32 CHAR) |
||
316 | 13:24e577240a06 | mohd | ) ; |
317 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
318 | -- DDL for Table TB_AM_TAC_BACKUP
|
||
319 | --------------------------------------------------------
|
||
320 | |||
321 | 13:24e577240a06 | mohd | CREATE TABLE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP" |
322 | 15:a225af95c3f1 | hadi | ( "OID" NUMBER(10,0) PRIMARY KEY, |
323 | 12:5440377775e9 | mohd | "T_USER_ID" NUMBER(10,0), |
324 | "T_TAC_CIPHERTEXT" VARCHAR2(64 CHAR), |
||
325 | "T_TAC_STATE" NUMBER(10,0), |
||
326 | 48:1142dd56945e | mohd | "T_DATE_GENERATED" TIMESTAMP, |
327 | "T_DATE_FIRST_USED" TIMESTAMP, |
||
328 | 12:5440377775e9 | mohd | "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 | 13:24e577240a06 | mohd | ) ; |
334 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
335 | -- DDL for Table TB_AM_USER
|
||
336 | --------------------------------------------------------
|
||
337 | |||
338 | 13:24e577240a06 | mohd | CREATE TABLE "M2U_UPASS_CI"."TB_AM_USER" |
339 | 15:a225af95c3f1 | hadi | ( "U_USER_ID" NUMBER(10,0) PRIMARY KEY, |
340 | 87:394ace09cbff | hadi | "U_USER_ALIAS" VARCHAR2(50 CHAR) unique, |
341 | 12:5440377775e9 | mohd | "U_USER_TYPE" NUMBER(10,0), |
342 | "U_USER_DESC" VARCHAR2(40 CHAR), |
||
343 | 48:1142dd56945e | mohd | "U_DATE_CREATED" TIMESTAMP, |
344 | "U_DATE_LAST_USED" TIMESTAMP, |
||
345 | 82:999497720cfa | hadi | "U_USE_COUNT" NUMBER(19,0), |
346 | 48:1142dd56945e | mohd | "U_DATE_LAST_ACT" TIMESTAMP, |
347 | "U_DATE_LAST_LOCK" TIMESTAMP, |
||
348 | 12:5440377775e9 | mohd | "U_USER_STATE" NUMBER(10,0), |
349 | 48:1142dd56945e | mohd | "U_DATE_LOCK_FROM" TIMESTAMP, |
350 | "U_DATE_LOCK_TO" TIMESTAMP, |
||
351 | 12:5440377775e9 | mohd | "P_PASSWD_CIPHERTEXT" VARCHAR2(64 CHAR), |
352 | "P_PASSWD_STATE" NUMBER(10,0), |
||
353 | 48:1142dd56945e | mohd | "P_DATE_GENERATED" TIMESTAMP, |
354 | "P_DATE_FIRST_USED" TIMESTAMP, |
||
355 | "P_DATE_LAST_USED" TIMESTAMP, |
||
356 | 82:999497720cfa | hadi | "P_USE_COUNT" NUMBER(19,0), |
357 | 12:5440377775e9 | mohd | "P_ERROR_COUNT" NUMBER(10,0), |
358 | "P_EXPIRED_STATUS" NUMBER(10,0), |
||
359 | 48:1142dd56945e | mohd | "P_DATE_EXPIRED" TIMESTAMP, |
360 | 97:07f14f4a83fb | hadi | "P_PASSWD_HIST" VARCHAR(1024), |
361 | 12:5440377775e9 | mohd | "U_APPLICATION_ID" NUMBER(10,0) |
362 | 13:24e577240a06 | mohd | ) ; |
363 | 87:394ace09cbff | hadi | |
364 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
365 | -- DDL for Table TB_AM_USERMAS
|
||
366 | --------------------------------------------------------
|
||
367 | |||
368 | 13:24e577240a06 | mohd | CREATE TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" |
369 | 15:a225af95c3f1 | hadi | ( "M_USER_ALIAS" VARCHAR2(20 CHAR) PRIMARY KEY, |
370 | 12:5440377775e9 | mohd | "M_USER_ID" NUMBER(10,0) |
371 | 13:24e577240a06 | mohd | ) ; |
372 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
373 | -- DDL for Table TB_AM_USERMAS_BACKUP
|
||
374 | --------------------------------------------------------
|
||
375 | |||
376 | 13:24e577240a06 | mohd | CREATE TABLE "M2U_UPASS_CI"."TB_AM_USERMAS_BACKUP" |
377 | 15:a225af95c3f1 | hadi | ( "M_USER_ALIAS" VARCHAR2(50 CHAR) PRIMARY KEY, |
378 | 12:5440377775e9 | mohd | "M_USER_ID" NUMBER(10,0) |
379 | 13:24e577240a06 | mohd | ) ; |
380 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
381 | -- DDL for Table TB_AM_USER_BACKUP
|
||
382 | --------------------------------------------------------
|
||
383 | |||
384 | 13:24e577240a06 | mohd | CREATE TABLE "M2U_UPASS_CI"."TB_AM_USER_BACKUP" |
385 | 15:a225af95c3f1 | hadi | ( "OID" NUMBER(10,0) PRIMARY KEY, |
386 | 12:5440377775e9 | mohd | "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 | 48:1142dd56945e | mohd | "U_DATE_CREATED" TIMESTAMP, |
391 | "U_DATE_LAST_USED" TIMESTAMP, |
||
392 | 82:999497720cfa | hadi | "U_USE_COUNT" NUMBER(19,0), |
393 | 48:1142dd56945e | mohd | "U_DATE_LAST_ACT" TIMESTAMP, |
394 | "U_DATE_LAST_LOCK" TIMESTAMP, |
||
395 | 12:5440377775e9 | mohd | "U_USER_STATE" NUMBER(10,0), |
396 | 48:1142dd56945e | mohd | "U_DATE_LOCK_FROM" TIMESTAMP, |
397 | "U_DATE_LOCK_TO" TIMESTAMP, |
||
398 | 12:5440377775e9 | mohd | "P_PASSWD_CIPHERTEXT" VARCHAR2(64 CHAR), |
399 | "P_PASSWD_STATE" NUMBER(10,0), |
||
400 | 48:1142dd56945e | mohd | "P_DATE_GENERATED" TIMESTAMP, |
401 | "P_DATE_FIRST_USED" TIMESTAMP, |
||
402 | "P_DATE_LAST_USED" TIMESTAMP, |
||
403 | 82:999497720cfa | hadi | "P_USE_COUNT" NUMBER(19,0), |
404 | 12:5440377775e9 | mohd | "P_ERROR_COUNT" NUMBER(10,0), |
405 | "P_EXPIRED_STATUS" NUMBER(10,0), |
||
406 | 48:1142dd56945e | mohd | "P_DATE_EXPIRED" TIMESTAMP, |
407 | 97:07f14f4a83fb | hadi | "P_PASSWD_HIST" VARCHAR2(1024 CHAR), |
408 | 12:5440377775e9 | mohd | "U_APPLICATION_ID" NUMBER(10,0) |
409 | 13:24e577240a06 | mohd | ) ; |
410 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
411 | -- DDL for Table TB_AM_VASCO
|
||
412 | --------------------------------------------------------
|
||
413 | |||
414 | 13:24e577240a06 | mohd | CREATE TABLE "M2U_UPASS_CI"."TB_AM_VASCO" |
415 | 15:a225af95c3f1 | hadi | ( "V_SERIAL_NO" VARCHAR2(22 CHAR) PRIMARY KEY, |
416 | 12:5440377775e9 | mohd | "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 | 48:1142dd56945e | mohd | "V_DATE_ASSIGNED" TIMESTAMP, |
423 | "V_DATE_FIRST_USED" TIMESTAMP, |
||
424 | "V_DATE_LAST_USED" TIMESTAMP, |
||
425 | 12:5440377775e9 | mohd | "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 | 13:24e577240a06 | mohd | ) ; |
430 | 12:5440377775e9 | mohd | |
431 | 48:1142dd56945e | mohd | --------------------------------------------------------
|
432 | -- DDL for Table ADMIN_ACTION
|
||
433 | --------------------------------------------------------
|
||
434 | |||
435 | CREATE TABLE "M2U_UPASS_CI"."ADMIN_ACTION" |
||
436 | 84:7fd247272805 | hadi | ( "ACTION_ID" NUMBER(38,2) PRIMARY KEY, |
437 | 48:1142dd56945e | mohd | "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 | 121:ca4e64425e8c | mohd | 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 | 13:24e577240a06 | mohd | 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 | 101:935361ebd907 | hadi | 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 | 13:24e577240a06 | mohd | 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 | 101:935361ebd907 | hadi | 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 | 13:24e577240a06 | mohd | 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 | 121:ca4e64425e8c | mohd | 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 | 13:24e577240a06 | mohd | 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 | 57:66ab29696441 | mohd | 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 | 13:24e577240a06 | mohd | 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 | 57:66ab29696441 | mohd | 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 | 13:24e577240a06 | mohd | 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 | 57:66ab29696441 | mohd | 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 | 13:24e577240a06 | mohd | 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 | 57:66ab29696441 | mohd | 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 | 13:24e577240a06 | mohd | 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 | 57:66ab29696441 | mohd | 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 | 13:24e577240a06 | mohd | 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 | 57:66ab29696441 | mohd | 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 | 13:24e577240a06 | mohd | 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 | 121:ca4e64425e8c | mohd | 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 | 13:24e577240a06 | mohd | 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 | 121:ca4e64425e8c | mohd | 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 | 13:24e577240a06 | mohd | 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 | 57:66ab29696441 | mohd | 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 | 13:24e577240a06 | mohd | 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 | 57:66ab29696441 | mohd | 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 | 13:24e577240a06 | mohd | 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 | 60:caa3ad4a3c74 | mohd | 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 | 13:24e577240a06 | mohd | 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 | 121:ca4e64425e8c | mohd | 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 | 58:077576134e91 | mohd | 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 | 12:5440377775e9 | mohd | |
880 | 13:24e577240a06 | mohd | 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 | 12:5440377775e9 | mohd | |
883 | 121:ca4e64425e8c | mohd | 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 | 12:5440377775e9 | mohd | |
891 | 70:4d8837885a5c | mohd | Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('root',1); |
892 | 121:ca4e64425e8c | mohd | Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('administrator',2); |
893 | 13:24e577240a06 | mohd | 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 | 48:1142dd56945e | mohd | |
901 | 84:7fd247272805 | hadi | 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 | 48:1142dd56945e | mohd | 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 | 81:f5062d3b03ba | mohd | 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 | 84:7fd247272805 | hadi | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8004); |
938 | 48:1142dd56945e | mohd | |
939 | 121:ca4e64425e8c | mohd | 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 | 69:81980247d82b | mohd | |
941 | 121:ca4e64425e8c | mohd | 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 | 69:81980247d82b | mohd | |
944 | 121:ca4e64425e8c | mohd | 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 | 69:81980247d82b | mohd | |
954 | |||
955 | 71:171bb6d347a4 | mohd | 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 | 48:1142dd56945e | mohd | 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 | 71:171bb6d347a4 | mohd | 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 | 81:f5062d3b03ba | mohd | 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 | 48:1142dd56945e | mohd | |
965 | 121:ca4e64425e8c | mohd | 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 | 48:1142dd56945e | mohd | |
969 | 121:ca4e64425e8c | mohd | 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 | 48:1142dd56945e | mohd | |
971 | 55:4d457cd85dc2 | hadi | 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 | 57:66ab29696441 | mohd | 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 | 52:7c5432c4668e | mohd | |
983 | 57:66ab29696441 | mohd | |
984 | 52:7c5432c4668e | mohd | --------------------------------------------------------
|
985 | 12:5440377775e9 | mohd | -- Constraints for Table TB_AM_TAC
|
986 | --------------------------------------------------------
|
||
987 | |||
988 | 13:24e577240a06 | mohd | 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 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
993 | -- Constraints for Table TB_AM_GEMALTO
|
||
994 | --------------------------------------------------------
|
||
995 | |||
996 | 13:24e577240a06 | mohd | 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 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
1005 | -- Constraints for Table TB_AM_USERMAS
|
||
1006 | --------------------------------------------------------
|
||
1007 | |||
1008 | 13:24e577240a06 | mohd | 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 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
1011 | -- Constraints for Table TB_AM_USER_BACKUP
|
||
1012 | --------------------------------------------------------
|
||
1013 | |||
1014 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
1015 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
1016 | -- Constraints for Table TB_AM_APPSERV
|
||
1017 | --------------------------------------------------------
|
||
1018 | |||
1019 | 13:24e577240a06 | mohd | 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 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
1024 | -- Constraints for Table TB_AM_CONFIG_CHANGE
|
||
1025 | --------------------------------------------------------
|
||
1026 | |||
1027 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG_CHANGE" MODIFY ("CONFIG_UPDATE" NOT NULL ENABLE); |
1028 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
1029 | -- Constraints for Table TB_AM_TAC_BACKUP
|
||
1030 | --------------------------------------------------------
|
||
1031 | |||
1032 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
1033 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
1034 | -- Constraints for Table SMS_TABLE
|
||
1035 | --------------------------------------------------------
|
||
1036 | |||
1037 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."SMS_TABLE" MODIFY ("OID" NOT NULL ENABLE); |
1038 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
1039 | -- Constraints for Table TB_AM_VASCO
|
||
1040 | --------------------------------------------------------
|
||
1041 | |||
1042 | 13:24e577240a06 | mohd | 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 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
1051 | -- Constraints for Table TB_AM_CONFIG
|
||
1052 | --------------------------------------------------------
|
||
1053 | |||
1054 | 13:24e577240a06 | mohd | 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 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
1058 | -- Constraints for Table TB_AM_USERMAS_BACKUP
|
||
1059 | --------------------------------------------------------
|
||
1060 | |||
1061 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS_BACKUP" MODIFY ("M_USER_ALIAS" NOT NULL ENABLE); |
1062 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
1063 | -- Constraints for Table TB_AM_USER
|
||
1064 | --------------------------------------------------------
|
||
1065 | |||
1066 | 13:24e577240a06 | mohd | 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 | 48:1142dd56945e | mohd | |
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 | 52:7c5432c4668e | mohd | 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) |