--------------------------------------------------------
  --  File created - Thursday-March-19-2015
  --------------------------------------------------------
  INSERT INTO `financial_institution`(
      `id`,
      `code`,
      `ip_address`,
      `switch_key`,
      `name`,
      `account_opening_end_point`,
      `is_enabled`
  ) VALUES (
      1,
      '001',
      NULL,
      NULL,
      'LMFB',
      'http://localhost:9898/entry-point/doAccountOpening',
      1
   );


  INSERT INTO `branch`(
      `id`,
      `branch_name`,
      `branch_code`,
      `is_enabled`,
      `financial_institution_id`
  ) VALUES (
      1,
      'HeadQuaters',
      '001',
      1,
      1
   );





  INSERT INTO `user`(
      `id`,
      `username`,
      `password_hash`,
      `is_enabled`,
      `group_id`,
      `branch_id`,
      `financial_institution_id`
  ) VALUES (
      1,
      'admin',
      '$2a$10$jTLZEU9vlR2r5WhBt4Mr2.yiMLgiY88buL7elDSGrPlHVQA0s6zGe',
      1,
      NULL,
      1,
      1
   );


  INSERT INTO "dsa" ("id","till_account","user_id") VALUES (4,'33333',1);
  INSERT INTO "dsa" ("id","till_account","user_id") VALUES (5,'5656533',3);




  INSERT INTO "config" ("id","config_name","config_value","financial_institution_id") VALUES (1,'ALLOW_TRAN_WEEKEND',1,1);
  INSERT INTO "config" ("id","config_name","config_value","financial_institution_id") VALUES (2,'ALLOW_ACCOUNT_OPENING_WEEKEND',0,1);
  INSERT INTO "config" ("id","config_name","config_value","financial_institution_id") VALUES (3,'CUSTOMER_DEPOSIT_LIMIT',10000,1);
  INSERT INTO "config" ("id","config_name","config_value","financial_institution_id") VALUES (4,'OFFLINE_ACCOUNT_OPENING',0,1);
  INSERT INTO "config" ("id","config_name","config_value","financial_institution_id") VALUES (5,'CUSTOMER_DEPOSIT_LIMIT_VELOCITY',5,1);
  INSERT INTO "config" ("id","config_name","config_value","financial_institution_id") VALUES (6,'DSA_DEPOSIT_LIMIT',20000,1);
  INSERT INTO "config" ("id","config_name","config_value","financial_institution_id") VALUES (7,'DSA_DEPOSIT_VELOCITY_LIMIT',5,1);
  INSERT INTO "config" ("id","config_name","config_value","financial_institution_id") VALUES (8,'CUSTOMER_WITHDRAWAL_LIMIT_VELOCITY',2,1);
  INSERT INTO "config" ("id","config_name","config_value","financial_institution_id") VALUES (9,'CUSTOMER_WITHDRAWAL_LIMIT',2000,1);

  INSERT INTO "privilege" ("id","name","description") VALUES (1,'View Account Opening','User can view account opening');
  INSERT INTO "privilege" ("id","name","description") VALUES (2,'View Users','User can view users');
  INSERT INTO "privilege" ("id","name","description") VALUES (3,'Update Devices','User can update device information');
  INSERT INTO "privilege" ("id","name","description") VALUES (4,'View Audits','User can view application audits');
  INSERT INTO "privilege" ("id","name","description") VALUES (5,'Create Users','User can create users');
  INSERT INTO "privilege" ("id","name","description") VALUES (6,'Edit Users','User can edit users');
  INSERT INTO "privilege" ("id","name","description") VALUES (7,'Disable Users','User can disable users');
  INSERT INTO "privilege" ("id","name","description") VALUES (8,'Enable Users','User can enable users');
  INSERT INTO "privilege" ("id","name","description") VALUES (9,'View Reports','User can view application reports');
  INSERT INTO "privilege" ("id","name","description") VALUES (10,'View Transactions','User can view transactions');
  INSERT INTO "privilege" ("id","name","description") VALUES (11,'Update Users','User can update users');
  INSERT INTO "privilege" ("id","name","description") VALUES (12,'Create Dsa','User can create dsa');
  INSERT INTO "privilege" ("id","name","description") VALUES (13,'View Dsas','User can view dsas');
  INSERT INTO "privilege" ("id","name","description") VALUES (14,'Create Branch','User can create branch');
  INSERT INTO "privilege" ("id","name","description") VALUES (15,'Edit Branch','User can edit branch');
  INSERT INTO "privilege" ("id","name","description") VALUES (16,'View Branch','User can view branches');
  INSERT INTO "privilege" ("id","name","description") VALUES (17,'Enable Branch','User can enable branch');
  INSERT INTO "privilege" ("id","name","description") VALUES (18,'Disable Branch','User can disable branch');
  INSERT INTO "privilege" ("id","name","description") VALUES (19,'View Configuration','User can view configuration');
  INSERT INTO "privilege" ("id","name","description") VALUES (20,'Edit Configuration','User can edit configuration');
  INSERT INTO "privilege" ("id","name","description") VALUES (21,'View Devices','User can view devices');
  INSERT INTO "privilege" ("id","name","description") VALUES (22,'Create Device','User can create device');
  INSERT INTO "privilege" ("id","name","description") VALUES (23,'Edit Device','User can edit device');
  INSERT INTO "privilege" ("id","name","description") VALUES (24,'Enable Device','User can enable device');
  INSERT INTO "privilege" ("id","name","description") VALUES (25,'Disable Device','User can disable device');
  INSERT INTO "privilege" ("id","name","description") VALUES (26,'Create Holiday','User can create holiday');
  INSERT INTO "privilege" ("id","name","description") VALUES (27,'View Holiday','User can view holiday');
  INSERT INTO "privilege" ("id","name","description") VALUES (28,'Edit Holiday','User can view holiday');

  INSERT INTO "user_profile" ("id","first_name","last_name","middle_name","email","phone_number","staff_number","user_id") VALUES (8,'Afolabi','Adewale','A','afolabi.adewale@longbridgetech.com','08025426934','0000006',1);
  INSERT INTO "user_profile" ("id","first_name","last_name","middle_name","email","phone_number","staff_number","user_id") VALUES (11,'A','A','A','adewaleafolabi2@gmail.com','080','0',2);
  INSERT INTO "user_profile" ("id","first_name","last_name","middle_name","email","phone_number","staff_number","user_id") VALUES (12,'Abdul','Man','Rah','aafolabi@biznesautomations.com','+235272727272','54969944333',3);
  INSERT INTO "user_profile" ("id","first_name","last_name","middle_name","email","phone_number","staff_number","user_id") VALUES (13,'Abdul','Man','Rah','aafolabssi@biznesautomations.com','+23527272727222','54969944333sss',5);

  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (1,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (2,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (3,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (4,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (5,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (6,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (7,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (8,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (9,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (10,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (11,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (12,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (13,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (14,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (15,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (16,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (17,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (18,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (19,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (20,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (21,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (22,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (23,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (24,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (25,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (26,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (27,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (28,1);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (1,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (2,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (3,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (4,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (5,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (6,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (7,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (8,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (9,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (10,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (11,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (12,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (13,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (14,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (15,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (16,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (17,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (18,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (19,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (20,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (21,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (22,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (23,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (24,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (25,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (26,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (27,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (28,2);
  INSERT INTO "user_privilege" ("privilege_id","user_id") VALUES (4,5);