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