Revision 70:4d8837885a5c

View differences:

test/resources/db-scripts/m2u-upass-ci-oracle.sql
879 879
Insert into M2U_UPASS_CI.TB_AM_CONFIG_CHANGE (CONFIG_UPDATE) values (1);
880 880
Insert into M2U_UPASS_CI.TB_AM_CONFIG_CHANGE (CONFIG_UPDATE) values (2);
881 881

  
882
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (1,'root',0,'Root ID',to_date('18-MAY-10','DD-MON-RR'),to_date('30-JUN-11','DD-MON-RR'),19,null,null,0,null,null,'98C59EB488E5B2AB34AC9FF1D032ADE917917965C66EF9963A921A67B008BBFF',0,to_date('18-MAY-10','DD-MON-RR'),to_date('18-MAY-10','DD-MON-RR'),to_date('30-JUN-11','DD-MON-RR'),19,0,1,null,0);
883
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (12,'UpassAdmin',1,'Admin',to_date('26-NOV-10','DD-MON-RR'),to_date('22-APR-13','DD-MON-RR'),3256,null,to_date('10-DEC-12','DD-MON-RR'),0,to_date('10-DEC-12','DD-MON-RR'),to_date('10-DEC-12','DD-MON-RR'),'E4B812847959F723BCC8D4DA5561F0F8F01FC94B3A8275F840F6AA4811F40940',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);
882 884
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (57,'administrator',1,'MSS Admin',to_date('01-DEC-10','DD-MON-RR'),to_date('05-APR-13','DD-MON-RR'),14477,to_date('05-APR-13','DD-MON-RR'),to_date('05-APR-13','DD-MON-RR'),0,to_date('05-APR-13','DD-MON-RR'),to_date('05-APR-13','DD-MON-RR'),'CD0661AA22CF155A8F55780AB6693FCF09FBCEBFC30666B1C30A4F297E375D4E',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);
883 885
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (100,'ibuser1',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'85F554525AAB11236FF53D707851447AD1096DFA67A9A77E5469A12C5724CE7C',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,1);
884 886
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (101,'ibuser2',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'AE647AB8E5263B29C01123C96C03BB80E849B377F8F7BDE791DA91B19E1D70E8',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,2);
......
888 890
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (105,'ibuser6',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'BD4CF661D7EEBC5F4F9DA263C5F40D6ED7E3B260',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null);
889 891
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (106,'ibuser7',2,'Description',to_date('15-DEC-10','DD-MON-RR'),null,0,null,null,0,null,null,'CFE07A6E720E205E6210BDBA5ED1473845856F56',0,to_date('15-DEC-10','DD-MON-RR'),null,null,0,0,1,null,null);
890 892

  
893
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('root',1);
894
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('UpassAdmin',12);
891 895
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('administrator',57);
892 896
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser1',100);
893 897
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ibuser2',101);
test/resources/db-scripts/m2u-upass-ci-oracle.sql_full
1128 1128
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 (581,'abc123',2,' ',to_date('23-AUG-11','DD-MON-RR'),to_date('25-AUG-11','DD-MON-RR'),5,to_date('23-AUG-11','DD-MON-RR'),null,0,null,null,'DA4B75F4723AEEFA641B8C1144E9AD3252ED56DF',0,to_date('23-AUG-11','DD-MON-RR'),null,null,0,0,1,null,null);
1129 1129
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 (582,'kingston89',2,' ',to_date('23-AUG-11','DD-MON-RR'),to_date('25-AUG-11','DD-MON-RR'),4,to_date('24-AUG-11','DD-MON-RR'),null,0,null,null,'0BA353992C0CF164BA60A8C07B1C29659D4668AD',0,to_date('23-AUG-11','DD-MON-RR'),null,null,0,0,1,null,null);
1130 1130
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 (586,'deleteuserr',2,'iBAM User',to_date('24-AUG-11','DD-MON-RR'),to_date('16-DEC-11','DD-MON-RR'),5,to_date('24-AUG-11','DD-MON-RR'),to_date('16-DEC-11','DD-MON-RR'),0,null,null,'E093C7CD23ABA45CEB7CC31BE8D2B56129705EC2',0,to_date('24-AUG-11','DD-MON-RR'),to_date('24-AUG-11','DD-MON-RR'),to_date('24-AUG-11','DD-MON-RR'),2,0,1,null,1);
1131
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,'98C59EB488E5B2AB34AC9FF1D032ADE917917965C66EF9963A921A67B008BBFF',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);
1132 1131
Insert into M2U_UPASS_CI.TB_AM_USER (U_USER_ID,U_USER_ALIAS,U_USER_TYPE,U_USER_DESC,U_DATE_CREATED,U_DATE_LAST_USED,U_USE_COUNT,U_DATE_LAST_ACT,U_DATE_LAST_LOCK,U_USER_STATE,U_DATE_LOCK_FROM,U_DATE_LOCK_TO,P_PASSWD_CIPHERTEXT,P_PASSWD_STATE,P_DATE_GENERATED,P_DATE_FIRST_USED,P_DATE_LAST_USED,P_USE_COUNT,P_ERROR_COUNT,P_EXPIRED_STATUS,P_DATE_EXPIRED,U_APPLICATION_ID) values (2,'TokenOwner',1,'TokenOwner',to_date('18-MAY-10','DD-MON-RR'),to_date('26-NOV-10','DD-MON-RR'),24,null,null,0,null,null,'9400A88AD1B95D467A1E13388C2D46399B8E7826',0,to_date('18-MAY-10','DD-MON-RR'),to_date('18-MAY-10','DD-MON-RR'),to_date('26-NOV-10','DD-MON-RR'),24,0,1,null,0);
1133 1132
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 (6,'admin',2,'admin',to_date('27-MAY-10','DD-MON-RR'),to_date('09-DEC-10','DD-MON-RR'),2627,null,null,0,null,null,'3C9CDD92DBBB12FAB3A1DB16854BE34D8E28C559',0,to_date('27-MAY-10','DD-MON-RR'),to_date('27-MAY-10','DD-MON-RR'),to_date('09-DEC-10','DD-MON-RR'),2627,0,1,null,null);
1134
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'),'E4B812847959F723BCC8D4DA5561F0F8F01FC94B3A8275F840F6AA4811F40940',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);
1135 1133
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 (15,'ibuser',2,' ',to_date('26-NOV-10','DD-MON-RR'),to_date('13-OCT-11','DD-MON-RR'),10766,to_date('13-OCT-11','DD-MON-RR'),to_date('13-OCT-11','DD-MON-RR'),0,null,null,'4E844A73445B9AC9E67AF51BF628E492E7F6951B',0,to_date('26-NOV-10','DD-MON-RR'),to_date('26-NOV-10','DD-MON-RR'),to_date('13-OCT-11','DD-MON-RR'),10713,0,1,null,null);
1136 1134
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'),'CD0661AA22CF155A8F55780AB6693FCF09FBCEBFC30666B1C30A4F297E375D4E',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);
1137 1135
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 (65,'bernardxx',2,'Description',to_date('02-DEC-10','DD-MON-RR'),to_date('12-DEC-10','DD-MON-RR'),14,null,null,0,null,null,'418F39E0FB8C4C8D78DCC77A3E4FE6B6B65E3B81',0,to_date('02-DEC-10','DD-MON-RR'),to_date('02-DEC-10','DD-MON-RR'),to_date('08-DEC-10','DD-MON-RR'),9,0,1,null,null);
......
2029 2027
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ribuser3',129);
2030 2028
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('ribuser4',130);
2031 2029
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('rooney10',679);
2032
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('root',1);
2033 2030
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('rossa160682',678);
2034 2031
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('sal_mah',517);
2035 2032
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('sam123',653);
......
2127 2124
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('training',714);
2128 2125
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('training1',715);
2129 2126
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('trytocreate',405);
2130
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('UpassAdmin',12);
2131 2127
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('upassCust',1009);
2132 2128
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('upassTester',998);
2133 2129
Insert into M2U_UPASS_CI.TB_AM_USERMAS (M_USER_ALIAS,M_USER_ID) values ('upassTester-Deleted',998);
......
4783 4779
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 (11,'Test role','TEsting Description for this role',0,0,to_timestamp('28/06/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_date('28/06/2011','DD/MM/RRRR'));
4784 4780
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 (12,'Test role','TEsting Description for this role',0,0,to_timestamp('28/06/2011 00:00:00.000000000','DD/MM/RRRR HH24:MI:SSXFF'),to_date('28/06/2011','DD/MM/RRRR'));
4785 4781

  
4786
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);
4787 4782
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 (728,1,1,'Backup Administrator',null,'mail@mail.com',null,null,null,null,0,0,to_date('15/09/2011','DD/MM/RRRR'),to_date('30/11/2011','DD/MM/RRRR'),0,0,null,null,null);
4788 4783
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 (807,1,655,'NOOR AZREEN SABRI',null,'azreen@agrobank.com.my',null,null,'0326142707','0326142707',728,807,to_date('21/05/2013','DD/MM/RRRR'),to_date('21/05/2013','DD/MM/RRRR'),0,0,'172.16.5.46','ict-azreen.agrobank.bpmb.local',null);
4789 4784
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 (808,1,655,'CCPR 1',null,'pr1@agrobank.com.my',null,null,'123456789','123456789',807,12,to_date('12/03/2013','DD/MM/RRRR'),to_date('30/03/2012','DD/MM/RRRR'),0,0,'172.16.5.46','ict-azreen.agrobank.bpmb.local',null);
......
5278 5273
Insert into M2U_UPASS_CI.IB_CUST_PROFILE (USER_ID,USER_NAME,USER_DOB_BRD,USER_EMAIL,USER_GENDER,USER_RACE,USER_HOME_PHONE,USER_OFFICE_PHONE,USER_MOBILE_PHONE,USER_TAC_PHONE,USER_ADDR1,USER_ADDR2,USER_ADDR3,USER_ADDR4,USER_ADDR5,USER_ACCESS_NO,USER_TYPE,UPDATED_BY,USER_CITY,USER_STATE,USER_POSTCODE,USER_COUNTRY,USER_AGE_RANGE,USER_INCOME_RANGE,USER_MARITAL_STATUS,USER_EMPLOY_STATUS,USER_EDUCATION_LEVEL,USER_DISPLAY_NAME,INSIDER,INQUIRY_CODE,MOTHER_MAIDEN_NAME,NATIONALITY,BUMI,RESIDENCE,RELIGION_CODE,LANGUAGE,CUST_STATUS,DECEASED,HOLD_MAIL_CODE,PROMO_MAIL_CODE,ADDRESS_SEQ,RETENTION,CONSITUTION,PLACE_OF_BIRTH,CUST_SEGMENT_CODE,NO_OF_EMP,HIGH_RISK,HIGH_RISK_CODE,STAFF_FLAG,STAFF_ID_NO,DURATION_STAY_PRE_ADD,HOUSE_OWNER_CODE,TYPE_DWELLING,NO_OF_DEPENDENTS,BUSS_PREMISE_CODE,BUSSINESS_TYPE,BUSS_OPER_HOURS,ID_NO,ID_TYPE,SALUTATION,BRANCH_NO,OFFICE_CONTACT_NAME,FAX,FAX_CONTACT_NAME,YEAR,ANNUAL_TURNOVER,SECTOR,NO_FULLTIME_EMP,CLIENT_TYPE,MOBILE_NO_FLAG,GROUP_ID,ORG_ID,ROLE_ID,MK_PENDING,LAST_LOGIN_DATE,UPDATED_DATE,MARITAL_DATE,CUST_STATUS_DATE,DECEASED_DATE,START_RELATIONSHIP,REVIEW_DATE,CREATION_DATE) values (996,'MOHD ARIF BIN YAHYA','19540207',' ','M',' ',' ',' ',' ','60148133959','NO. 20 JALAN HJ MD LAZIM','SEDILI BESAR',' ','81900 KOTA TINGGI, JOHORE',null,'220611221','01',980,'KOTA TINGGI, JOHORE','1','81900','MY',59,null,0,null,null,'MOHD ARIF BIN YAHYA',' ',' ',' ','MY','Y','Y','I',' ','1','N','N','N','1','Y','I',' ',' ',0,'N',' ',' ',' ',0,' ',' ',0,' ',' ','0','540207015435','IN',' ',1061,null,null,null,0,0,null,0,null,'1',1,0,1,0,to_date('07/05/2013','DD/MM/RRRR'),to_date('07/05/2013','DD/MM/RRRR'),null,null,null,null,null,to_date('23/11/1999','DD/MM/RRRR'));
5279 5274
Insert into M2U_UPASS_CI.IB_CUST_PROFILE (USER_ID,USER_NAME,USER_DOB_BRD,USER_EMAIL,USER_GENDER,USER_RACE,USER_HOME_PHONE,USER_OFFICE_PHONE,USER_MOBILE_PHONE,USER_TAC_PHONE,USER_ADDR1,USER_ADDR2,USER_ADDR3,USER_ADDR4,USER_ADDR5,USER_ACCESS_NO,USER_TYPE,UPDATED_BY,USER_CITY,USER_STATE,USER_POSTCODE,USER_COUNTRY,USER_AGE_RANGE,USER_INCOME_RANGE,USER_MARITAL_STATUS,USER_EMPLOY_STATUS,USER_EDUCATION_LEVEL,USER_DISPLAY_NAME,INSIDER,INQUIRY_CODE,MOTHER_MAIDEN_NAME,NATIONALITY,BUMI,RESIDENCE,RELIGION_CODE,LANGUAGE,CUST_STATUS,DECEASED,HOLD_MAIL_CODE,PROMO_MAIL_CODE,ADDRESS_SEQ,RETENTION,CONSITUTION,PLACE_OF_BIRTH,CUST_SEGMENT_CODE,NO_OF_EMP,HIGH_RISK,HIGH_RISK_CODE,STAFF_FLAG,STAFF_ID_NO,DURATION_STAY_PRE_ADD,HOUSE_OWNER_CODE,TYPE_DWELLING,NO_OF_DEPENDENTS,BUSS_PREMISE_CODE,BUSSINESS_TYPE,BUSS_OPER_HOURS,ID_NO,ID_TYPE,SALUTATION,BRANCH_NO,OFFICE_CONTACT_NAME,FAX,FAX_CONTACT_NAME,YEAR,ANNUAL_TURNOVER,SECTOR,NO_FULLTIME_EMP,CLIENT_TYPE,MOBILE_NO_FLAG,GROUP_ID,ORG_ID,ROLE_ID,MK_PENDING,LAST_LOGIN_DATE,UPDATED_DATE,MARITAL_DATE,CUST_STATUS_DATE,DECEASED_DATE,START_RELATIONSHIP,REVIEW_DATE,CREATION_DATE) values (997,'SIM KIAN TONG','19650322',' ','M',' ','019-7622365',' ',' ','60123555423','382 JALAN KURAU 3,','SUNGAI RENGIT',' ','81620 PENGERANG',null,'280384456','01',0,'PENGERANG','1','81620','MY',48,null,0,null,null,'SIM KIAN TONG',' ',' ',' ','MY','Y','Y','I',' ','1','N','N','N','1','Y','I',' ',' ',0,'N',' ',' ',' ',0,' ',' ',0,' ',' ','0','650322015227','IN',' ',1061,null,null,null,0,0,null,0,null,'1',1,0,1,0,to_date('05/04/2013','DD/MM/RRRR'),to_date('05/04/2013','DD/MM/RRRR'),null,null,null,null,null,to_date('11/08/2003','DD/MM/RRRR'));
5280 5275

  
5281
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'));
5282 5276
Insert into M2U_UPASS_CI.IB_USER (USER_ID,ACCOUNT_ID,USER_ALIAS,PASSWORD,USER_STATE,MODIF_TIME,CREATION_DATE) values (728,0,'security',null,0,to_date('15/09/2011','DD/MM/RRRR'),to_date('15/09/2011','DD/MM/RRRR'));
5283 5277
Insert into M2U_UPASS_CI.IB_USER (USER_ID,ACCOUNT_ID,USER_ALIAS,PASSWORD,USER_STATE,MODIF_TIME,CREATION_DATE) values (802,0,'pussycat61',null,0,to_date('23/07/2012','DD/MM/RRRR'),to_date('03/11/2011','DD/MM/RRRR'));
5284 5278
Insert into M2U_UPASS_CI.IB_USER (USER_ID,ACCOUNT_ID,USER_ALIAS,PASSWORD,USER_STATE,MODIF_TIME,CREATION_DATE) values (803,0,'BabyHasnol',null,2,to_date('12/03/2013','DD/MM/RRRR'),to_date('03/11/2011','DD/MM/RRRR'));

Also available in: Unified diff