m2u-upass-ws / test / resources / db-scripts / m2u-upass-ci-oracle.sql @ 118:1602007a5ca3
History | View | Annotate | Download (80.2 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 | 97:07f14f4a83fb | hadi | "P_PASSWD_HIST" VARCHAR(1024), |
| 363 | 12:5440377775e9 | mohd | "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 | 97:07f14f4a83fb | hadi | "P_PASSWD_HIST" VARCHAR2(1024 CHAR), |
| 410 | 12:5440377775e9 | mohd | "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 | 101:935361ebd907 | hadi | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CHANGE_PASSWORD_INTERVAL','0', EMPTY_CLOB(),0,0); |
| 782 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CHANGE_PASSWORD_INTERVAL','1', EMPTY_CLOB(),1,1); |
||
| 783 | 13:24e577240a06 | mohd | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CHANGE_PASSWORD_INTERVAL','1', EMPTY_CLOB(),2,0); |
| 784 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CHANGE_PASSWORD_INTERVAL','1', EMPTY_CLOB(),3,0); |
||
| 785 | 101:935361ebd907 | hadi | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CHANGE_PASSWORD_INTERVAL','0', EMPTY_CLOB(),4,0); |
| 786 | 13:24e577240a06 | mohd | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('IBAM_SECURE_MESSAGE','1', EMPTY_CLOB(),1,1); |
| 787 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('IBAM_SECURE_MESSAGE','1', EMPTY_CLOB(),0,0); |
||
| 788 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('NOTIF_ALERT','1', EMPTY_CLOB(),0,0); |
||
| 789 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('AUTO_LOGOFF','1', EMPTY_CLOB(),0,0); |
||
| 790 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DEACTIVATE_PERIOD','1', EMPTY_CLOB(),0,0); |
||
| 791 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SINGLE_SIGNON','1', EMPTY_CLOB(),0,0); |
||
| 792 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('CONFIG_CHANGE','1', EMPTY_CLOB(),0,0); |
||
| 793 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_ACCEPT_PATTERN','^[a-zA-Z0-9]{0,}$', EMPTY_CLOB(),3,0); |
||
| 794 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_ACCEPT_PATTERN','^[a-zA-Z0-9]{0,}$', EMPTY_CLOB(),1,1); |
||
| 795 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_ACCEPT_PATTERN','^[a-zA-Z0-9]{0,}$', EMPTY_CLOB(),2,0); |
||
| 796 | 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); |
| 797 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_ACCEPT_PATTERN','^[a-zA-Z0-9]{0,}$', EMPTY_CLOB(),5,0); |
||
| 798 | 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); |
| 799 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY','0', EMPTY_CLOB(),3,0); |
||
| 800 | 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); |
| 801 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY','0', EMPTY_CLOB(),5,0); |
||
| 802 | 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); |
| 803 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY','1', EMPTY_CLOB(),2,0); |
||
| 804 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY','0', EMPTY_CLOB(),0,0); |
||
| 805 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_LOWER_ALPHA','0', EMPTY_CLOB(),3,0); |
||
| 806 | 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); |
| 807 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_LOWER_ALPHA','0', EMPTY_CLOB(),5,0); |
||
| 808 | 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); |
| 809 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_LOWER_ALPHA','0', EMPTY_CLOB(),2,0); |
||
| 810 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_LOWER_ALPHA','0', EMPTY_CLOB(),0,0); |
||
| 811 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_NUMERIC','0', EMPTY_CLOB(),3,0); |
||
| 812 | 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); |
| 813 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_NUMERIC','0', EMPTY_CLOB(),5,0); |
||
| 814 | 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); |
| 815 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_NUMERIC','0', EMPTY_CLOB(),2,0); |
||
| 816 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_NUMERIC','0', EMPTY_CLOB(),0,0); |
||
| 817 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_SYMBOL','1', EMPTY_CLOB(),3,0); |
||
| 818 | 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); |
| 819 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_SYMBOL','1', EMPTY_CLOB(),5,0); |
||
| 820 | 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); |
| 821 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_SYMBOL','1', EMPTY_CLOB(),2,0); |
||
| 822 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_SYMBOL','0', EMPTY_CLOB(),0,0); |
||
| 823 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_UPPER_ALPHA','0', EMPTY_CLOB(),3,0); |
||
| 824 | 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); |
| 825 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_UPPER_ALPHA','0', EMPTY_CLOB(),5,0); |
||
| 826 | 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); |
| 827 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_UPPER_ALPHA','0', EMPTY_CLOB(),2,0); |
||
| 828 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_COMPLEXITY_UPPER_ALPHA','0', EMPTY_CLOB(),0,0); |
||
| 829 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','30', EMPTY_CLOB(),3,0); |
||
| 830 | 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); |
| 831 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','30', EMPTY_CLOB(),5,0); |
||
| 832 | 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); |
| 833 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','31', EMPTY_CLOB(),2,0); |
||
| 834 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_EXPIRY_DAY','0', EMPTY_CLOB(),0,0); |
||
| 835 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','5', EMPTY_CLOB(),3,0); |
||
| 836 | 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); |
| 837 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','5', EMPTY_CLOB(),5,0); |
||
| 838 | 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); |
| 839 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','5', EMPTY_CLOB(),2,0); |
||
| 840 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_GENERATION','6', EMPTY_CLOB(),0,0); |
||
| 841 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MAX_ERROR','3', EMPTY_CLOB(),3,0); |
||
| 842 | 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); |
| 843 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MAX_ERROR','3', EMPTY_CLOB(),5,0); |
||
| 844 | 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); |
| 845 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MAX_ERROR','3', EMPTY_CLOB(),2,0); |
||
| 846 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MAX_ERROR','3', EMPTY_CLOB(),0,0); |
||
| 847 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MIN_LENGTH','8', EMPTY_CLOB(),3,0); |
||
| 848 | 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); |
| 849 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MIN_LENGTH','8', EMPTY_CLOB(),5,0); |
||
| 850 | 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); |
| 851 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MIN_LENGTH','9', EMPTY_CLOB(),2,0); |
||
| 852 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_MIN_LENGTH','1', EMPTY_CLOB(),0,0); |
||
| 853 | 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); |
| 854 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-zA-Z]).{8,12}', EMPTY_CLOB(),1,1); |
||
| 855 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-zA-Z]).{8,12}', EMPTY_CLOB(),2,0); |
||
| 856 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-zA-Z]).{8,12}', EMPTY_CLOB(),4,0); |
||
| 857 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-zA-Z]).{8,12}', EMPTY_CLOB(),5,0); |
||
| 858 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('PASSWORD_PATTERN','(?=.*[0-9])(?=.*[a-zA-Z]).{8,12}', EMPTY_CLOB(),0,0); |
||
| 859 | 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); |
| 860 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SC_LIFTSPAN_TIMEOUT','86400', EMPTY_CLOB(),0,0); |
||
| 861 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SC_MAX_ERROR','3', EMPTY_CLOB(),0,0); |
||
| 862 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SC_MAX_USE','1', EMPTY_CLOB(),0,0); |
||
| 863 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('SC_REPEAT_TIMEOUT','1', EMPTY_CLOB(),0,0); |
||
| 864 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_DEFAULT_TIMEOUT','300', EMPTY_CLOB(),0,0); |
||
| 865 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_LIFTSPAN_TIMEOUT','300', EMPTY_CLOB(),0,0); |
||
| 866 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_MAX_ERROR','3', EMPTY_CLOB(),0,0); |
||
| 867 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_MAX_USE','1', EMPTY_CLOB(),0,0); |
||
| 868 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_MAX_USE','1', EMPTY_CLOB(),2,0); |
||
| 869 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_REPEAT_TIMEOUT','60', EMPTY_CLOB(),0,0); |
||
| 870 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('TAC_REPEAT_TIMEOUT','30', EMPTY_CLOB(),2,0); |
||
| 871 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','30', EMPTY_CLOB(),3,0); |
||
| 872 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','30', EMPTY_CLOB(),1,1); |
||
| 873 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','30', EMPTY_CLOB(),2,0); |
||
| 874 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USER_DORMANT_PERIOD','0', EMPTY_CLOB(),0,0); |
||
| 875 | 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); |
| 876 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),4,0); |
||
| 877 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),5,0); |
||
| 878 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),1,1); |
||
| 879 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),2,0); |
||
| 880 | Insert into M2U_UPASS_CI.TB_AM_CONFIG (CONFIG_NAME,CONFIG_VALUE,CONFIG_DESCRIPTION,APPLICATION_ID,MK_PENDING) values ('USERNAME_PATTERN','^[a-zA-Z0-9\\._-]{6,16}$', EMPTY_CLOB(),0,0); |
||
| 881 | 12:5440377775e9 | mohd | |
| 882 | 13:24e577240a06 | mohd | Insert into M2U_UPASS_CI.TB_AM_CONFIG_CHANGE (CONFIG_UPDATE) values (1); |
| 883 | Insert into M2U_UPASS_CI.TB_AM_CONFIG_CHANGE (CONFIG_UPDATE) values (2); |
||
| 884 | 12:5440377775e9 | mohd | |
| 885 | 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); |
| 886 | Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (12,'UpassAdmin',1,'Admin',to_date('26-NOV-10','DD-MON-RR'),to_date('22-APR-13','DD-MON-RR'),3256,null,to_date('10-DEC-12','DD-MON-RR'),0,to_date('10-DEC-12','DD-MON-RR'),to_date('10-DEC-12','DD-MON-RR'),'7AABD6A7DF0B1F24A1996D57DD6E7ADA35ED56CA884996E4205C722F3EC139D6',0,to_date('26-NOV-10','DD-MON-RR'),to_date('26-NOV-10','DD-MON-RR'),to_date('09-MAY-13','DD-MON-RR'),4529,0,1,null,0); |
||
| 887 | 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); |
| 888 | 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); |
| 889 | Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (101,'ibuser2',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'9382596D75FDF7DB48FA6BD0F3EB41587331F4340F5A3656D2F886406F290022',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,2); |
||
| 890 | Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (102,'ibuser3',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'BA2D69FB001B6A21FE5005528E8CFEEEA6C939D47E0CD383DD0D61295848FD89',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,3); |
||
| 891 | Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (103,'ibuser4',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'98C3D7E8CD74B22374703C31D182E56355B6830D5B648E8202883565881A88F6',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,4); |
||
| 892 | Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (104,'ibuser5',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'19264C925BB223D518D9284441353949FDA028FAABA3153DBA9752C3C89A7C28',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,5); |
||
| 893 | 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); |
| 894 | Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (106,'ibuser7',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'CFE07A6E720E205E6210BDBA5ED1473845856F56',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null); |
||
| 895 | 12:5440377775e9 | mohd | |
| 896 | 70:4d8837885a5c | mohd | Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('root',1); |
| 897 | Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('UpassAdmin',12); |
||
| 898 | 13:24e577240a06 | mohd | Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('administrator',57); |
| 899 | Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser1',100); |
||
| 900 | Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser2',101); |
||
| 901 | Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser3',102); |
||
| 902 | Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser4',103); |
||
| 903 | Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser5',104); |
||
| 904 | Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser6',105); |
||
| 905 | Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser7',106); |
||
| 906 | 48:1142dd56945e | mohd | |
| 907 | 84:7fd247272805 | hadi | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (1021,'Unlock Customer',0,0); |
| 908 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (1023,'Activate Customer',0,0); |
||
| 909 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3002,'Edit USS Navigation',1,0); |
||
| 910 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3011,'Create USS Group',1,0); |
||
| 911 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3012,'Edit USS Group',1,0); |
||
| 912 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3013,'Delete USS Group',1,0); |
||
| 913 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3021,'Create USS User',1,0); |
||
| 914 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3022,'Edit USS User',1,0); |
||
| 915 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3023,'Delete USS User',1,0); |
||
| 916 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3024,'Suspend USS User',1,0); |
||
| 917 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3025,'Activate USS User',1,0); |
||
| 918 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3026,'Unlock USS User',1,0); |
||
| 919 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3027,'Reset Password for USS User',1,0); |
||
| 920 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (3031,'Edit UPASS Configs',1,0); |
||
| 921 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (8001,'Create Application Admin',1,0); |
||
| 922 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (8002,'Edit Application Admin',1,0); |
||
| 923 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (8003,'Delete Application Admin',1,0); |
||
| 924 | Insert into M2U_UPASS_CI.ADMIN_ACTION (ACTION_ID,ACTION,APPROVABLE,MK_PENDING) values (8004,'Reset Password for Application Admin',1,0); |
||
| 925 | |||
| 926 | 48:1142dd56945e | mohd | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (1,1021); |
| 927 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (1,1023); |
||
| 928 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3021); |
||
| 929 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3022); |
||
| 930 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3023); |
||
| 931 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3024); |
||
| 932 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3025); |
||
| 933 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3026); |
||
| 934 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (3,3027); |
||
| 935 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (6,3002); |
||
| 936 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (7,3011); |
||
| 937 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (7,3012); |
||
| 938 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (7,3013); |
||
| 939 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (35,3031); |
||
| 940 | 81:f5062d3b03ba | mohd | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8001); |
| 941 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8002); |
||
| 942 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8003); |
||
| 943 | 84:7fd247272805 | hadi | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_ACTION (NAVIGATION_ID,ACTION_ID) values (36,8004); |
| 944 | 48:1142dd56945e | mohd | |
| 945 | 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); |
| 946 | |||
| 947 | Insert into M2U_UPASS_CI.ADMIN_GROUP (GROUP_ID,GROUP_NAME,GROUP_DESCRIPTION,GROUP_CREATED_BY,GROUP_UPDATED_BY,GROUP_CREATION_DATE,GROUP_UPDATED_DATE,CATEGORY,GROUP_LVL,MODE_TYPE,MK_PENDING) values (0,'Ungrouped','No group',12,12,to_date('12/09/2011','DD/MM/RRRR'),to_date('12/09/2011','DD/MM/RRRR'),1,9,'1',0); |
||
| 948 | Insert into M2U_UPASS_CI.ADMIN_GROUP (GROUP_ID,GROUP_NAME,GROUP_DESCRIPTION,GROUP_CREATED_BY,GROUP_UPDATED_BY,GROUP_CREATION_DATE,GROUP_UPDATED_DATE,CATEGORY,GROUP_LVL,MODE_TYPE,MK_PENDING) values (1,'System Administrator','System ID',0,12,to_date('05/12/2010','DD/MM/RRRR'),to_date('06/12/2010','DD/MM/RRRR'),1,0,'1',0); |
||
| 949 | |||
| 950 | 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); |
| 951 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (7,19,'Admin Group Maintenance ','Assign User Role to a Specific Group of Admin User','1','0','SSSSAGRP',2,'/ss103/groupEnquiryMain.do',6,12,to_timestamp('06/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('30/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
||
| 952 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (3,19,'Admin User Maintenance','Maintain IBAM Admin users','1','0','SSSSAENQ',3,'/ss102/userEnquiryScreen.do',6,12,to_timestamp('09/11/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('23/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
||
| 953 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (6,19,'Menu Maintenance','To maintain IBAM Navigation','1','0','SSSSNAVI',4,'/ss100/navigationEnquiryMain.do',6,822,to_timestamp('09/11/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('06/12/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
||
| 954 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (1,19,'Customer Enquiry','RIB User Enquiry','1','0','SSSSUENQ',5,'/ss112/searchUser.do',6,12,to_timestamp('09/11/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('27/07/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
||
| 955 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (8,19,'USS Audit Log','Audit Log','1','0','SSSSALOG',6,'/ss104/auditTrailMain.do',6,12,to_timestamp('06/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('23/10/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
||
| 956 | 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); |
| 957 | 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); |
| 958 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION (NODE_ID,PARENT_ID,NODE_NAME,NODE_DESCRIPTION,NODE_TYPE,NODE_STATUS,NODE_CODE,NODE_DISPLAY_ORDER,PAGE_PATH,NODE_CREATED_BY,NODE_UPDATED_BY,NODE_CREATION_DATE,NODE_UPDATED_DATE,CATEGORY,NODE_SYSTEM,MK_PENDING) values (36,19,'Application Admin Maintenance','To Maintain Application Admin','1','0','SSSSAUM',9,'/ss223/appUserEnquiryMain.do',1,12,to_timestamp('17/02/2012 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_timestamp('30/06/2013 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),1,'IBAM',0); |
||
| 959 | 69:81980247d82b | mohd | |
| 960 | |||
| 961 | 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'); |
| 962 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (3,1,0,0,'SSSSAENQ'); |
||
| 963 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (6,1,0,0,'SSSSNAVI'); |
||
| 964 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (7,1,0,0,'SSSSAGRP'); |
||
| 965 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (8,1,0,0,'SSSSALOG'); |
||
| 966 | 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'); |
| 967 | 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'); |
| 968 | Insert into M2U_UPASS_CI.ADMIN_NAVIGATION_GROUP (NAVIGATION_ID,GROUP_ID,IS_EDIT,IS_VIEW,NODE_CODE) values (35,1,0,0,'SSSSSETT'); |
||
| 969 | 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'); |
| 970 | 48:1142dd56945e | mohd | |
| 971 | 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')); |
| 972 | 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')); |
| 973 | Insert into M2U_UPASS_CI.ADMIN_ROLE (ROLE_ID,ROLE_NAME,ROLE_DESCRIPTION,ROLE_CREATED_BY,ROLE_UPDATED_BY,ROLE_CREATION_DATE,ROLE_UPDATED_DATE) values (2,'Admin','Admin',1,1,to_timestamp('15/12/2010 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),null); |
||
| 974 | |||
| 975 | Insert into M2U_UPASS_CI.IB_USER (USER_ID,ACCOUNT_ID,USER_ALIAS,PASSWORD,USER_STATE,MODIF_TIME,CREATION_DATE) values (12,0,'administrator',null,0,to_date('05/12/2010','DD/MM/RRRR'),to_date('05/12/2010','DD/MM/RRRR')); |
||
| 976 | |||
| 977 | 55:4d457cd85dc2 | hadi | Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (1, 'M2U Retail Internet Banking'); |
| 978 | Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (2, 'Maybank Online Stock'); |
||
| 979 | Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (3, 'Maybank Online Ticketing'); |
||
| 980 | Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (4, 'Maybank CCPP'); |
||
| 981 | Insert into M2U_UPASS_CI.CLIENT_APP (APP_ID, APP_NAME) values (5, 'M2U Singapore Integration'); |
||
| 982 | |||
| 983 | 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); |
| 984 | Insert into M2U_UPASS_CI.USER_APP_ACCESS (access_type, app_id, registration_time, user_id) values ('A', 2, to_date('03/03/2013','DD/MM/RRRR'), 101); |
||
| 985 | Insert into M2U_UPASS_CI.USER_APP_ACCESS (access_type, app_id, registration_time, user_id) values ('A', 3, to_date('03/03/2013','DD/MM/RRRR'), 102); |
||
| 986 | Insert into M2U_UPASS_CI.USER_APP_ACCESS (access_type, app_id, registration_time, user_id) values ('A', 4, to_date('03/03/2013','DD/MM/RRRR'), 103); |
||
| 987 | Insert into M2U_UPASS_CI.USER_APP_ACCESS (access_type, app_id, registration_time, user_id) values ('A', 5, to_date('03/03/2013','DD/MM/RRRR'), 104); |
||
| 988 | 52:7c5432c4668e | mohd | |
| 989 | 57:66ab29696441 | mohd | |
| 990 | 52:7c5432c4668e | mohd | --------------------------------------------------------
|
| 991 | 12:5440377775e9 | mohd | -- Constraints for Table TB_AM_TAC
|
| 992 | --------------------------------------------------------
|
||
| 993 | |||
| 994 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_ERROR_COUNT" NOT NULL ENABLE); |
| 995 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_USE_COUNT" NOT NULL ENABLE); |
||
| 996 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_TAC_STATE" NOT NULL ENABLE); |
||
| 997 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC" MODIFY ("T_USER_ID" NOT NULL ENABLE); |
||
| 998 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
| 999 | -- Constraints for Table TB_AM_GEMALTO
|
||
| 1000 | --------------------------------------------------------
|
||
| 1001 | |||
| 1002 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_DP_STATE" NOT NULL ENABLE); |
| 1003 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_ERROR_COUNT" NOT NULL ENABLE); |
||
| 1004 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_USE_COUNT" NOT NULL ENABLE); |
||
| 1005 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_DP_ASSIGNED" NOT NULL ENABLE); |
||
| 1006 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_BAK_CIPHERTEXT" NOT NULL ENABLE); |
||
| 1007 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_DP_CIPHERTEXT" NOT NULL ENABLE); |
||
| 1008 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_USER_ID" NOT NULL ENABLE); |
||
| 1009 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_GEMALTO" MODIFY ("G_SERIAL_NO" NOT NULL ENABLE); |
||
| 1010 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
| 1011 | -- Constraints for Table TB_AM_USERMAS
|
||
| 1012 | --------------------------------------------------------
|
||
| 1013 | |||
| 1014 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" MODIFY ("M_USER_ID" NOT NULL ENABLE); |
| 1015 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS" MODIFY ("M_USER_ALIAS" NOT NULL ENABLE); |
||
| 1016 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
| 1017 | -- Constraints for Table TB_AM_USER_BACKUP
|
||
| 1018 | --------------------------------------------------------
|
||
| 1019 | |||
| 1020 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
| 1021 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
| 1022 | -- Constraints for Table TB_AM_APPSERV
|
||
| 1023 | --------------------------------------------------------
|
||
| 1024 | |||
| 1025 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_APP_SERV_ACCESS2" NOT NULL ENABLE); |
| 1026 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_APP_SERV_ACCESS1" NOT NULL ENABLE); |
||
| 1027 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_APP_SERV_ID" NOT NULL ENABLE); |
||
| 1028 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_APPSERV" MODIFY ("A_USER_ID" NOT NULL ENABLE); |
||
| 1029 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
| 1030 | -- Constraints for Table TB_AM_CONFIG_CHANGE
|
||
| 1031 | --------------------------------------------------------
|
||
| 1032 | |||
| 1033 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG_CHANGE" MODIFY ("CONFIG_UPDATE" NOT NULL ENABLE); |
| 1034 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
| 1035 | -- Constraints for Table TB_AM_TAC_BACKUP
|
||
| 1036 | --------------------------------------------------------
|
||
| 1037 | |||
| 1038 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_TAC_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
| 1039 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
| 1040 | -- Constraints for Table SMS_TABLE
|
||
| 1041 | --------------------------------------------------------
|
||
| 1042 | |||
| 1043 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."SMS_TABLE" MODIFY ("OID" NOT NULL ENABLE); |
| 1044 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
| 1045 | -- Constraints for Table TB_AM_VASCO
|
||
| 1046 | --------------------------------------------------------
|
||
| 1047 | |||
| 1048 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_DP_STATE" NOT NULL ENABLE); |
| 1049 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_ERROR_COUNT" NOT NULL ENABLE); |
||
| 1050 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_USE_COUNT" NOT NULL ENABLE); |
||
| 1051 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_DP_ASSIGNED" NOT NULL ENABLE); |
||
| 1052 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_BAK_CIPHERTEXT" NOT NULL ENABLE); |
||
| 1053 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_DP_CIPHERTEXT" NOT NULL ENABLE); |
||
| 1054 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_USER_ID" NOT NULL ENABLE); |
||
| 1055 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_VASCO" MODIFY ("V_SERIAL_NO" NOT NULL ENABLE); |
||
| 1056 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
| 1057 | -- Constraints for Table TB_AM_CONFIG
|
||
| 1058 | --------------------------------------------------------
|
||
| 1059 | |||
| 1060 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
| 1061 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" MODIFY ("APPLICATION_ID" NOT NULL ENABLE); |
||
| 1062 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_CONFIG" MODIFY ("CONFIG_NAME" NOT NULL ENABLE); |
||
| 1063 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
| 1064 | -- Constraints for Table TB_AM_USERMAS_BACKUP
|
||
| 1065 | --------------------------------------------------------
|
||
| 1066 | |||
| 1067 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USERMAS_BACKUP" MODIFY ("M_USER_ALIAS" NOT NULL ENABLE); |
| 1068 | 12:5440377775e9 | mohd | --------------------------------------------------------
|
| 1069 | -- Constraints for Table TB_AM_USER
|
||
| 1070 | --------------------------------------------------------
|
||
| 1071 | |||
| 1072 | 13:24e577240a06 | mohd | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_EXPIRED_STATUS" NOT NULL ENABLE); |
| 1073 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_ERROR_COUNT" NOT NULL ENABLE); |
||
| 1074 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_USE_COUNT" NOT NULL ENABLE); |
||
| 1075 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_DATE_GENERATED" NOT NULL ENABLE); |
||
| 1076 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("P_PASSWD_STATE" NOT NULL ENABLE); |
||
| 1077 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_STATE" NOT NULL ENABLE); |
||
| 1078 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USE_COUNT" NOT NULL ENABLE); |
||
| 1079 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_DATE_CREATED" NOT NULL ENABLE); |
||
| 1080 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_TYPE" NOT NULL ENABLE); |
||
| 1081 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_ALIAS" NOT NULL ENABLE); |
||
| 1082 | ALTER TABLE "M2U_UPASS_CI"."TB_AM_USER" MODIFY ("U_USER_ID" NOT NULL ENABLE); |
||
| 1083 | 48:1142dd56945e | mohd | |
| 1084 | --------------------------------------------------------
|
||
| 1085 | -- Constraints for Table ADMIN_ACTION
|
||
| 1086 | --------------------------------------------------------
|
||
| 1087 | |||
| 1088 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_ACTION" MODIFY ("APPROVABLE" NOT NULL ENABLE); |
||
| 1089 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_ACTION" MODIFY ("ACTION" NOT NULL ENABLE); |
||
| 1090 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_ACTION" MODIFY ("ACTION_ID" NOT NULL ENABLE); |
||
| 1091 | --------------------------------------------------------
|
||
| 1092 | -- Constraints for Table ADMIN_AUDIT_LOG
|
||
| 1093 | --------------------------------------------------------
|
||
| 1094 | |||
| 1095 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("LOG_CREATION_DATE" NOT NULL ENABLE); |
||
| 1096 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("LOG_DESCRIPTION" NOT NULL ENABLE); |
||
| 1097 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("AUDIT_CATEGORY_ID" NOT NULL ENABLE); |
||
| 1098 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_AUDIT_LOG" MODIFY ("LOG_ID" NOT NULL ENABLE); |
||
| 1099 | --------------------------------------------------------
|
||
| 1100 | -- Constraints for Table ADMIN_GROUP
|
||
| 1101 | --------------------------------------------------------
|
||
| 1102 | |||
| 1103 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_LVL" NOT NULL ENABLE); |
||
| 1104 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_CREATION_DATE" NOT NULL ENABLE); |
||
| 1105 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_NAME" NOT NULL ENABLE); |
||
| 1106 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_GROUP" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
||
| 1107 | --------------------------------------------------------
|
||
| 1108 | -- Constraints for Table ADMIN_NAVIGATION
|
||
| 1109 | --------------------------------------------------------
|
||
| 1110 | |||
| 1111 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_CREATION_DATE" NOT NULL ENABLE); |
||
| 1112 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_CODE" NOT NULL ENABLE); |
||
| 1113 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_NAME" NOT NULL ENABLE); |
||
| 1114 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION" MODIFY ("NODE_ID" NOT NULL ENABLE); |
||
| 1115 | --------------------------------------------------------
|
||
| 1116 | -- Constraints for Table ADMIN_NAVIGATION_ACTION
|
||
| 1117 | --------------------------------------------------------
|
||
| 1118 | |||
| 1119 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_ACTION" MODIFY ("ACTION_ID" NOT NULL ENABLE); |
||
| 1120 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_ACTION" MODIFY ("NAVIGATION_ID" NOT NULL ENABLE); |
||
| 1121 | --------------------------------------------------------
|
||
| 1122 | -- Constraints for Table ADMIN_NAVIGATION_GROUP
|
||
| 1123 | --------------------------------------------------------
|
||
| 1124 | |||
| 1125 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("IS_VIEW" NOT NULL ENABLE); |
||
| 1126 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("IS_EDIT" NOT NULL ENABLE); |
||
| 1127 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
||
| 1128 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_NAVIGATION_GROUP" MODIFY ("NAVIGATION_ID" NOT NULL ENABLE); |
||
| 1129 | --------------------------------------------------------
|
||
| 1130 | -- Constraints for Table ADMIN_PERMISSION
|
||
| 1131 | --------------------------------------------------------
|
||
| 1132 | |||
| 1133 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" MODIFY ("IS_APPROVER" NOT NULL ENABLE); |
||
| 1134 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" MODIFY ("ACTION_ID" NOT NULL ENABLE); |
||
| 1135 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_PERMISSION" MODIFY ("USER_ID" NOT NULL ENABLE); |
||
| 1136 | --------------------------------------------------------
|
||
| 1137 | -- Constraints for Table ADMIN_ROLE
|
||
| 1138 | --------------------------------------------------------
|
||
| 1139 | |||
| 1140 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_ROLE" MODIFY ("ROLE_CREATION_DATE" NOT NULL ENABLE); |
||
| 1141 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_ROLE" MODIFY ("ROLE_NAME" NOT NULL ENABLE); |
||
| 1142 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_ROLE" MODIFY ("ROLE_ID" NOT NULL ENABLE); |
||
| 1143 | --------------------------------------------------------
|
||
| 1144 | -- Constraints for Table ADMIN_USER_PROFILE
|
||
| 1145 | --------------------------------------------------------
|
||
| 1146 | |||
| 1147 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
||
| 1148 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("FORCE_RESET" NOT NULL ENABLE); |
||
| 1149 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("USER_EMAIL" NOT NULL ENABLE); |
||
| 1150 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("USER_NAME" NOT NULL ENABLE); |
||
| 1151 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
||
| 1152 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("ROLE_ID" NOT NULL ENABLE); |
||
| 1153 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE" MODIFY ("USER_ID" NOT NULL ENABLE); |
||
| 1154 | --------------------------------------------------------
|
||
| 1155 | -- Constraints for Table ADMIN_USER_PROFILE_BACKUP
|
||
| 1156 | --------------------------------------------------------
|
||
| 1157 | |||
| 1158 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_PROFILE_BACKUP" MODIFY ("OID" NOT NULL ENABLE); |
||
| 1159 | --------------------------------------------------------
|
||
| 1160 | -- Constraints for Table ADMIN_USER_SECURITY
|
||
| 1161 | --------------------------------------------------------
|
||
| 1162 | |||
| 1163 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY" MODIFY ("USER_ID" NOT NULL ENABLE); |
||
| 1164 | --------------------------------------------------------
|
||
| 1165 | -- Constraints for Table ADMIN_USER_SECURITY_BACKUP
|
||
| 1166 | --------------------------------------------------------
|
||
| 1167 | |||
| 1168 | ALTER TABLE "M2U_UPASS_CI"."ADMIN_USER_SECURITY_BACKUP" MODIFY ("USER_ID" NOT NULL ENABLE); |
||
| 1169 | --------------------------------------------------------
|
||
| 1170 | -- Constraints for Table IB_CONTENT_CATEGORY
|
||
| 1171 | --------------------------------------------------------
|
||
| 1172 | |||
| 1173 | ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
||
| 1174 | ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("CONTENT_TYPE_ID" NOT NULL ENABLE); |
||
| 1175 | ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("CREATION_DATE" NOT NULL ENABLE); |
||
| 1176 | ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY" MODIFY ("OID" NOT NULL ENABLE); |
||
| 1177 | --------------------------------------------------------
|
||
| 1178 | -- Constraints for Table IB_CONTENT_TYPE
|
||
| 1179 | --------------------------------------------------------
|
||
| 1180 | |||
| 1181 | ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" MODIFY ("CREATION_DATE" NOT NULL ENABLE); |
||
| 1182 | ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" MODIFY ("CONTENT_TYPE_CODE" NOT NULL ENABLE); |
||
| 1183 | ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_TYPE" MODIFY ("OID" NOT NULL ENABLE); |
||
| 1184 | --------------------------------------------------------
|
||
| 1185 | -- Constraints for Table IB_CUST_PROFILE
|
||
| 1186 | --------------------------------------------------------
|
||
| 1187 | |||
| 1188 | ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("MK_PENDING" NOT NULL ENABLE); |
||
| 1189 | ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("ROLE_ID" NOT NULL ENABLE); |
||
| 1190 | ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("GROUP_ID" NOT NULL ENABLE); |
||
| 1191 | ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("NO_FULLTIME_EMP" NOT NULL ENABLE); |
||
| 1192 | ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("ANNUAL_TURNOVER" NOT NULL ENABLE); |
||
| 1193 | ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("YEAR" NOT NULL ENABLE); |
||
| 1194 | ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("BRANCH_NO" NOT NULL ENABLE); |
||
| 1195 | ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("NO_OF_DEPENDENTS" NOT NULL ENABLE); |
||
| 1196 | ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("DURATION_STAY_PRE_ADD" NOT NULL ENABLE); |
||
| 1197 | ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("NO_OF_EMP" NOT NULL ENABLE); |
||
| 1198 | ALTER TABLE "M2U_UPASS_CI"."IB_CUST_PROFILE" MODIFY ("USER_ID" NOT NULL ENABLE); |
||
| 1199 | --------------------------------------------------------
|
||
| 1200 | -- Constraints for Table IB_USER
|
||
| 1201 | --------------------------------------------------------
|
||
| 1202 | |||
| 1203 | ALTER TABLE "M2U_UPASS_CI"."IB_USER" MODIFY ("CREATION_DATE" NOT NULL ENABLE); |
||
| 1204 | ALTER TABLE "M2U_UPASS_CI"."IB_USER" MODIFY ("ACCOUNT_ID" NOT NULL ENABLE); |
||
| 1205 | ALTER TABLE "M2U_UPASS_CI"."IB_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
||
| 1206 | |||
| 1207 | --------------------------------------------------------
|
||
| 1208 | -- Constraints for Table IB_CONTENT_CATEGORY_ML
|
||
| 1209 | --------------------------------------------------------
|
||
| 1210 | |||
| 1211 | ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("CONTENT_CATEGORY_ID" NOT NULL ENABLE); |
||
| 1212 | ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("LOCALE" NOT NULL ENABLE); |
||
| 1213 | 52:7c5432c4668e | mohd | ALTER TABLE "M2U_UPASS_CI"."IB_CONTENT_CATEGORY_ML" MODIFY ("OID" NOT NULL ENABLE); |
| 1214 | |||
| 1215 | |||
| 1216 | ALTER TABLE "M2U_UPASS_CI"."M2U_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
||
| 1217 | ALTER TABLE "M2U_UPASS_CI"."TICKETING_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
||
| 1218 | ALTER TABLE "M2U_UPASS_CI"."IBCC_PUBLIC_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
||
| 1219 | ALTER TABLE "M2U_UPASS_CI"."STOCK_USER" MODIFY ("USER_ID" NOT NULL ENABLE); |
||
| 1220 | ALTER TABLE "M2U_UPASS_CI"."IM2U_USER" MODIFY ("USER_ID" NOT NULL ENABLE) |