Inicio Explorar Axuda
Rexistro Iniciar sesión
guanli
/
ngds
1
0
Fork 0
Ficheiros Incidencias 0 Pull Requests 0 Wiki
Árbore: 215c7f5440
Ramas Etiquetas
ngds
/
sql
/
upgrade
/
1708.sql

1708.sql 5.7 KB
Histórico Raw

1234567891011121314151617181920 
  1. TRUNCATE TABLE `AR_OPEN_BANK`;
    2. 

  2. 

  3. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('488C80A583CE34398C7206CAEF3F1A00', 'Access Bank Nigeria Plc', '488C80A583CE34398C7206CAEF3F1A00', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    4. 

  4. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('F081A012321E37F3A5719370941A1EEA', 'Access Bank Plc (Diamond)', 'F081A012321E37F3A5719370941A1EEA', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    5. 

  5. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('3F555F1E33BF3A54A5155DA23E3A0C42', 'Eco Bank Plc', '3F555F1E33BF3A54A5155DA23E3A0C42', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    6. 

  6. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('36D5A393EA33338AA777104B2CBF4D16', 'Fidelity Bank Plc', '36D5A393EA33338AA777104B2CBF4D16', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    7. 

  7. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('506644E92E803DC8B562E8AE975F050E', 'First Bank Plc', '506644E92E803DC8B562E8AE975F050E', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    8. 

  8. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('52F359DD3F643D458173BDC640520C05', 'First City monument Bank', '52F359DD3F643D458173BDC640520C05', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    9. 

  9. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('879FFBBD62F83D6CAA9B4F88D9E2D96D', 'Guarantee trust Bank Plc', '879FFBBD62F83D6CAA9B4F88D9E2D96D', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    10. 

  10. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('6B36E4B6122830989D20ADD16E056F8B', 'Keystone Bank limited', '6B36E4B6122830989D20ADD16E056F8B', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    11. 

  11. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('F24030A1793237838AF4BC0C86891E79', 'Opay', 'F24030A1793237838AF4BC0C86891E79', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    12. 

  12. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('0CD12C63E2E33012A8CAA5B085C6846A', 'Polaris Bank limited', '0CD12C63E2E33012A8CAA5B085C6846A', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    13. 

  13. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('42BDC3236029343292B51E4C8EA9ED34', 'Providus Bank', '42BDC3236029343292B51E4C8EA9ED34', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    14. 

  14. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('C1EF53D27E04362CAD6D0CE435542FDE', 'Stanbic-IBTC Bank Plc', 'C1EF53D27E04362CAD6D0CE435542FDE', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    15. 

  15. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('8F5B96ADA5F63C08A931CDCA226A4284', 'Sterling Bank Plc', '8F5B96ADA5F63C08A931CDCA226A4284', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    16. 

  16. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('2286677B88AD3950912602DF4B29382D', 'UBA Plc', '2286677B88AD3950912602DF4B29382D', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    17. 

  17. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('ADB5C937B21631ED857737D70DE9E3B0', 'Union Bank', 'ADB5C937B21631ED857737D70DE9E3B0', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    18. 

  18. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('02924B6DEEB431018FDF9E1ACAF7AC52', 'Unity Bank Plc', '02924B6DEEB431018FDF9E1ACAF7AC52', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    19. 

  19. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('1DEB142687273F28A620DF32DE069005', 'Wema Bank Plc', '1DEB142687273F28A620DF32DE069005', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    20. 

  20. INSERT INTO `AR_OPEN_BANK` (`ID`, `BANK_NAME`, `BANK_CODE`, `LIST_ORDER`, `CREATED_AT`, `UPDATED_AT`, `ADM_NAME`, `MIN_CHARGE`, `MAX_CHARGE`, `CHARGE_PROP`, `UPDATER`, `STATUS`) VALUES ('F55D48B1A6243DE4BA27866D01196251', 'Zenith Bank Plc', 'F55D48B1A6243DE4BA27866D01196251', 0, 0, 0, 'admin', 0.00, 0.00, 0.00, '', 1);
    21.