Started GET "/" for ::1 at 2023-11-17 17:29:11 +0200
   (7.1ms)  SET NAMES utf8,  @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'),  @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483
  ↳ C:/Ruby27-x64/lib/ruby/gems/2.7.0/gems/activerecord-5.2.8.1/lib/active_record/log_subscriber.rb:98
   (0.6ms)  SELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASC
  ↳ C:/Ruby27-x64/lib/ruby/gems/2.7.0/gems/activerecord-5.2.8.1/lib/active_record/log_subscriber.rb:98
Processing by LoanCalculatorController#index as HTML
  Rendering loan_calculator/index.html.erb within layouts/loan_calculator
  Product Exists (1.6ms)  SELECT  1 AS one FROM `products` WHERE (featured = true) AND (id <= 3) LIMIT 1
  ↳ app/views/loan_calculator/_featured_products.html.erb:8
  Product Load (0.5ms)  SELECT `products`.* FROM `products` WHERE (featured = true) AND (id <= 3)
  ↳ app/views/loan_calculator/_featured_products.html.erb:9
  Product Exists (0.3ms)  SELECT  1 AS one FROM `products` WHERE (featured = true) AND (id BETWEEN 4 AND 6) LIMIT 1
  ↳ app/views/loan_calculator/_featured_products.html.erb:33
  Product Load (0.4ms)  SELECT `products`.* FROM `products` WHERE (featured = true) AND (id BETWEEN 4 AND 6)
  ↳ app/views/loan_calculator/_featured_products.html.erb:34
  Rendered loan_calculator/_featured_products.html.erb (61.4ms)
  Rendered loan_calculator/index.html.erb within layouts/loan_calculator (116.1ms)
  Product Load (0.6ms)  SELECT `products`.* FROM `products`
  ↳ app/views/layouts/_menu.html.erb:29
  Rendered layouts/_menu.html.erb (8.7ms)
  Rendered layouts/_slider.html.erb (0.5ms)
  Product Load (0.4ms)  SELECT `products`.* FROM `products` WHERE (featured = true)
  ↳ app/views/layouts/_footer.html.erb:17
  Rendered layouts/_footer.html.erb (4.6ms)
Completed 200 OK in 14315ms (Views: 14253.2ms | ActiveRecord: 27.8ms)


Started GET "/users/sign_in" for ::1 at 2023-11-17 17:29:42 +0200
Processing by Devise::SessionsController#new as HTML
  Rendering devise/sessions/new.html.erb within layouts/application
  Rendered devise/shared/_links.html.erb (2.6ms)
  Rendered devise/sessions/new.html.erb within layouts/application (278.6ms)
  Product Load (0.4ms)  SELECT `products`.* FROM `products`
  ↳ app/views/layouts/_menu.html.erb:29
  Rendered layouts/_menu.html.erb (7.1ms)
  Product Load (0.3ms)  SELECT `products`.* FROM `products` WHERE (featured = true)
  ↳ app/views/layouts/_footer.html.erb:17
  Rendered layouts/_footer.html.erb (9.9ms)
Completed 200 OK in 1469ms (Views: 1412.0ms | ActiveRecord: 35.4ms)


Started GET "/users/sign_up" for ::1 at 2023-11-17 17:29:52 +0200
Processing by Devise::RegistrationsController#new as HTML
  Rendering devise/registrations/new.html.erb within layouts/application
  Rendered devise/shared/_error_messages.html.erb (0.7ms)
  Rendered devise/shared/_links.html.erb (1.1ms)
  Rendered devise/registrations/new.html.erb within layouts/application (36.6ms)
  Product Load (0.3ms)  SELECT `products`.* FROM `products`
  ↳ app/views/layouts/_menu.html.erb:29
  Rendered layouts/_menu.html.erb (21.3ms)
  Product Load (0.3ms)  SELECT `products`.* FROM `products` WHERE (featured = true)
  ↳ app/views/layouts/_footer.html.erb:17
  Rendered layouts/_footer.html.erb (6.5ms)
Completed 200 OK in 867ms (Views: 865.4ms | ActiveRecord: 0.7ms)


   (1.5ms)  SET NAMES utf8,  @@SESSION.sql_mode = CONCAT(CONCAT(@@sql_mode, ',STRICT_ALL_TABLES'), ',NO_AUTO_VALUE_ON_ZERO'),  @@SESSION.sql_auto_is_null = 0, @@SESSION.wait_timeout = 2147483
  ↳ bin/rails:4
   (8.0ms)  CREATE TABLE `schema_migrations` (`version` varchar(255) NOT NULL PRIMARY KEY)
  ↳ bin/rails:4
   (1.9ms)  CREATE TABLE `ar_internal_metadata` (`key` varchar(255) NOT NULL PRIMARY KEY, `value` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL)
  ↳ bin/rails:4
   (0.4ms)  SELECT GET_LOCK('5819118608264770620', 0)
  ↳ bin/rails:4
   (0.3ms)  SELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASC
  ↳ bin/rails:4
Migrating to CreateProducts (20210316230542)
   (2.0ms)  CREATE TABLE `products` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` varchar(255), `description` text, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL)
  ↳ db/migrate/20210316230542_create_products.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (1.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210316230542')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateConfigKeyCategories (20210316231029)
   (1.8ms)  CREATE TABLE `config_key_categories` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` varchar(255))
  ↳ db/migrate/20210316231029_create_config_key_categories.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210316231029')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateConfigKeys (20210316231104)
   (2.9ms)  CREATE TABLE `config_keys` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `config_key_category_id` bigint, `name` varchar(255), `config_value` varchar(255),  INDEX `index_config_keys_on_config_key_category_id`  (`config_key_category_id`), CONSTRAINT `fk_rails_0da8810cec`
FOREIGN KEY (`config_key_category_id`)
  REFERENCES `config_key_categories` (`id`)
)
  ↳ db/migrate/20210316231104_create_config_keys.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210316231104')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateCurrencies (20210316233732)
   (1.4ms)  CREATE TABLE `currencies` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` varchar(255), `symbol` varchar(255), `rate` decimal(12,4) DEFAULT 0.0)
  ↳ db/migrate/20210316233732_create_currencies.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210316233732')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to DeviseCreateUsers (20210321083130)
   (1.3ms)  CREATE TABLE `users` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `email` varchar(255) DEFAULT '' NOT NULL, `encrypted_password` varchar(255) DEFAULT '' NOT NULL, `reset_password_token` varchar(255), `reset_password_sent_at` datetime, `remember_created_at` datetime, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL)
  ↳ db/migrate/20210321083130_devise_create_users.rb:5
   (3.7ms)  CREATE UNIQUE INDEX `index_users_on_email`  ON `users` (`email`) 
  ↳ db/migrate/20210321083130_devise_create_users.rb:39
   (2.0ms)  CREATE UNIQUE INDEX `index_users_on_reset_password_token`  ON `users` (`reset_password_token`) 
  ↳ db/migrate/20210321083130_devise_create_users.rb:40
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210321083130')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateCustomerTypes (20210322215430)
   (1.8ms)  CREATE TABLE `customer_types` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL)
  ↳ db/migrate/20210322215430_create_customer_types.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210322215430')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateLoanApplications (20210322221509)
   (3.3ms)  CREATE TABLE `loan_applications` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `user_id` bigint, `product_id` bigint, `loan_amount` decimal(18,4) DEFAULT 0.0 NOT NULL, `instalment` decimal(18,4) DEFAULT 0.0 NOT NULL, `interest` decimal(12,1) DEFAULT 0.0 NOT NULL, `tenor` int NOT NULL, `loan_purpose` varchar(255) NOT NULL, `collateral` varchar(255) NOT NULL, `calculation_mode` varchar(255) NOT NULL, `submitted` tinyint(1) DEFAULT FALSE, `approved` tinyint(1) DEFAULT FALSE, `approval_confirmation` varchar(255), `closed` tinyint(1) DEFAULT FALSE, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_loan_applications_on_user_id`  (`user_id`),  INDEX `index_loan_applications_on_product_id`  (`product_id`), CONSTRAINT `fk_rails_9e1223db12`
FOREIGN KEY (`user_id`)
  REFERENCES `users` (`id`)
, CONSTRAINT `fk_rails_d43f9404e9`
FOREIGN KEY (`product_id`)
  REFERENCES `products` (`id`)
)
  ↳ db/migrate/20210322221509_create_loan_applications.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210322221509')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateCustomers (20210322224300)
   (5.7ms)  CREATE TABLE `customers` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `loan_application_id` bigint, `customer_type_id` bigint, `firstname` varchar(255), `lastname` varchar(255), `customer_name` varchar(255) NOT NULL, `idnumber` varchar(255), `dob` date, `nationality` varchar(255), `property_ownership` varchar(255), `gender` varchar(255), `address_1` varchar(255), `address_2` varchar(255), `city` varchar(255), `country` varchar(255), `mobile_1` varchar(255) NOT NULL, `mobile_2` varchar(255), `email` varchar(255) NOT NULL, `district` varchar(255), `province` varchar(255), `employer_name` varchar(255), `employment_type` varchar(255), `ec_number` varchar(255), `department` varchar(255), `job_title` varchar(255), `banker` varchar(255), `banker_branch` varchar(255), `banker_account_number` varchar(255), `banker_account_name` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_customers_on_loan_application_id`  (`loan_application_id`),  INDEX `index_customers_on_customer_type_id`  (`customer_type_id`), CONSTRAINT `fk_rails_651b886807`
FOREIGN KEY (`loan_application_id`)
  REFERENCES `loan_applications` (`id`)
, CONSTRAINT `fk_rails_9e248b531a`
FOREIGN KEY (`customer_type_id`)
  REFERENCES `customer_types` (`id`)
)
  ↳ db/migrate/20210322224300_create_customers.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210322224300')
  ↳ bin/rails:4
   (0.2ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateLoanPurposes (20210324221446)
   (2.1ms)  CREATE TABLE `loan_purposes` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` varchar(255), `specify` tinyint(1), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL)
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:3
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:9
  LoanPurpose Create (0.4ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Distribution', FALSE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:9
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:9
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:10
  LoanPurpose Create (0.2ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Retail', FALSE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:10
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:10
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:11
  LoanPurpose Create (0.2ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Manufacturing', FALSE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:11
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:11
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:12
  LoanPurpose Create (0.2ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Consumption', FALSE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:12
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:12
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:13
  LoanPurpose Create (0.1ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Health', FALSE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:13
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:13
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:14
  LoanPurpose Create (0.1ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Services', FALSE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:14
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:14
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:15
  LoanPurpose Create (0.1ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Education', FALSE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:15
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:15
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:16
  LoanPurpose Create (0.1ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Mining', FALSE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:16
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:16
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:17
  LoanPurpose Create (0.1ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Agriculture', FALSE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:17
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:17
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:18
  LoanPurpose Create (0.1ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Cross Border Traders', FALSE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:18
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:18
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:19
  LoanPurpose Create (0.2ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Vendors', FALSE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:19
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:19
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:20
  LoanPurpose Create (0.1ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Funeral Assistance', FALSE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:20
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:20
   (0.1ms)  BEGIN
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:21
  LoanPurpose Create (0.2ms)  INSERT INTO `loan_purposes` (`name`, `specify`, `created_at`, `updated_at`) VALUES ('Other', TRUE, '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:21
   (0.1ms)  COMMIT
  ↳ db/migrate/20210324221446_create_loan_purposes.rb:21
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210324221446')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateProductConfigKeys (20210328202433)
   (1.7ms)  CREATE TABLE `product_config_keys` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `product_id` bigint, `config_key_id` bigint, `config_value` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_product_config_keys_on_product_id`  (`product_id`),  INDEX `index_product_config_keys_on_config_key_id`  (`config_key_id`), CONSTRAINT `fk_rails_4e2aaaa8c4`
FOREIGN KEY (`product_id`)
  REFERENCES `products` (`id`)
, CONSTRAINT `fk_rails_5b1fbcf38a`
FOREIGN KEY (`config_key_id`)
  REFERENCES `config_keys` (`id`)
)
  ↳ db/migrate/20210328202433_create_product_config_keys.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210328202433')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddApporovalIdToLoanApplication (20210331205452)
   (2.7ms)  ALTER TABLE `loan_applications` ADD `appid` text
  ↳ db/migrate/20210331205452_add_apporoval_id_to_loan_application.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210331205452')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddEmployerAddressToCustomer (20210331213941)
   (3.0ms)  ALTER TABLE `customers` ADD `employer_address` varchar(255)
  ↳ db/migrate/20210331213941_add_employer_address_to_customer.rb:3
   (1.7ms)  ALTER TABLE `customers` ADD `employer_phone` varchar(255)
  ↳ db/migrate/20210331213941_add_employer_address_to_customer.rb:4
   (1.7ms)  ALTER TABLE `customers` ADD `employer_email` varchar(255)
  ↳ db/migrate/20210331213941_add_employer_address_to_customer.rb:5
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210331213941')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateNextOfKins (20210401081436)
   (1.8ms)  CREATE TABLE `next_of_kins` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `customer_id` bigint, `firstname` varchar(255) NOT NULL, `lastname` varchar(255) NOT NULL, `fullname` varchar(255) NOT NULL, `idnumber` varchar(255), `address_1` varchar(255) NOT NULL, `address_2` varchar(255), `city` varchar(255), `mobile_1` varchar(255) NOT NULL, `mobile_2` varchar(255), `relation` varchar(255), `active` tinyint(1) DEFAULT FALSE, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_next_of_kins_on_customer_id`  (`customer_id`), CONSTRAINT `fk_rails_f51f257ea4`
FOREIGN KEY (`customer_id`)
  REFERENCES `customers` (`id`)
)
  ↳ db/migrate/20210401081436_create_next_of_kins.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210401081436')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateLoanApplicationAttachments (20210407074613)
   (2.2ms)  CREATE TABLE `loan_application_attachments` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `loan_application_id` bigint, `requirement_id` int NOT NULL, `description` varchar(255), `doc` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_loan_application_attachments_on_loan_application_id`  (`loan_application_id`), CONSTRAINT `fk_rails_5163e3187d`
FOREIGN KEY (`loan_application_id`)
  REFERENCES `loan_applications` (`id`)
)
  ↳ db/migrate/20210407074613_create_loan_application_attachments.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210407074613')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to DeviseCreateAdminUsers (20210412154820)
   (1.3ms)  CREATE TABLE `admin_users` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `email` varchar(255) DEFAULT '' NOT NULL, `encrypted_password` varchar(255) DEFAULT '' NOT NULL, `reset_password_token` varchar(255), `reset_password_sent_at` datetime, `remember_created_at` datetime, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL)
  ↳ db/migrate/20210412154820_devise_create_admin_users.rb:5
   (1.4ms)  CREATE UNIQUE INDEX `index_admin_users_on_email`  ON `admin_users` (`email`) 
  ↳ db/migrate/20210412154820_devise_create_admin_users.rb:39
   (1.4ms)  CREATE UNIQUE INDEX `index_admin_users_on_reset_password_token`  ON `admin_users` (`reset_password_token`) 
  ↳ db/migrate/20210412154820_devise_create_admin_users.rb:40
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210412154820')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateActiveAdminComments (20210412154830)
   (2.0ms)  CREATE TABLE `active_admin_comments` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `namespace` varchar(255), `body` text, `resource_type` varchar(255), `resource_id` bigint, `author_type` varchar(255), `author_id` bigint, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_active_admin_comments_on_resource_type_and_resource_id`  (`resource_type`, `resource_id`),  INDEX `index_active_admin_comments_on_author_type_and_author_id`  (`author_type`, `author_id`))
  ↳ db/migrate/20210412154830_create_active_admin_comments.rb:3
   (2.6ms)  CREATE  INDEX `index_active_admin_comments_on_namespace`  ON `active_admin_comments` (`namespace`) 
  ↳ db/migrate/20210412154830_create_active_admin_comments.rb:10
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210412154830')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddRolesToUser (20210415000313)
   (2.1ms)  ALTER TABLE `users` ADD `admin` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210415000313_add_roles_to_user.rb:3
   (3.0ms)  ALTER TABLE `users` ADD `supervisor` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210415000313_add_roles_to_user.rb:4
   (1.5ms)  ALTER TABLE `users` ADD `user` tinyint(1) DEFAULT TRUE
  ↳ db/migrate/20210415000313_add_roles_to_user.rb:5
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210415000313')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddSubProductToLoanApplication (20210415095747)
   (1.7ms)  ALTER TABLE `loan_applications` ADD `sub_product` varchar(255) DEFAULT 'personal'
  ↳ db/migrate/20210415095747_add_sub_product_to_loan_application.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210415095747')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateLoanApplicationAdditionals (20210415101525)
   (2.9ms)  CREATE TABLE `loan_application_additionals` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `loan_application_id` bigint, `ec_number` varchar(255), `department` varchar(255), `job_title` varchar(255), `dob` date, `idnumber` varchar(255), `nationality` varchar(255), `property_ownership` varchar(255), `doc` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_loan_application_additionals_on_loan_application_id`  (`loan_application_id`), CONSTRAINT `fk_rails_a03bc810f4`
FOREIGN KEY (`loan_application_id`)
  REFERENCES `loan_applications` (`id`)
)
  ↳ db/migrate/20210415101525_create_loan_application_additionals.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210415101525')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateRequirements (20210422101328)
   (1.7ms)  CREATE TABLE `requirements` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `description` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL)
  ↳ db/migrate/20210422101328_create_requirements.rb:3
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:8
  Requirement Create (0.2ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('National ID(s) or Passport(s)', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:8
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:8
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:9
  Requirement Create (0.2ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Proof of Residence(s)', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:9
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:9
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:10
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Passport Photos', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:10
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:10
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:11
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Current PaySlip', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:11
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:11
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:12
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('3 Months Bank Statement', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:12
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:12
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:13
  Requirement Create (0.2ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Confirmation Letter of Employment', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:13
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:13
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:14
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Guarantor/Collateral', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:14
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:14
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:15
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Guarantor', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:15
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:15
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:16
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Collateral', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:16
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:16
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:17
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Certificate of Incorporation', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:17
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:17
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:18
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Memorandum of Association', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:18
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:18
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:19
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Articles of Association', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:19
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:19
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:20
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('CR6', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:20
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:20
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:21
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('CR14', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:21
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:21
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:22
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Financial Statements', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:22
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:22
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:23
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Latest 6 Months Bank Statement', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:23
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:23
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:24
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Letter from the Issuer of Order', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:24
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:24
   (0.1ms)  BEGIN
  ↳ db/migrate/20210422101328_create_requirements.rb:25
  Requirement Create (0.1ms)  INSERT INTO `requirements` (`description`, `created_at`, `updated_at`) VALUES ('Company Profile', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ db/migrate/20210422101328_create_requirements.rb:25
   (0.1ms)  COMMIT
  ↳ db/migrate/20210422101328_create_requirements.rb:25
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210422101328')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateProductRequirements (20210422101652)
   (1.6ms)  CREATE TABLE `product_requirements` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `product_id` bigint, `requirement_id` bigint, `required` tinyint(1), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_product_requirements_on_product_id`  (`product_id`),  INDEX `index_product_requirements_on_requirement_id`  (`requirement_id`), CONSTRAINT `fk_rails_a80b35af54`
FOREIGN KEY (`product_id`)
  REFERENCES `products` (`id`)
, CONSTRAINT `fk_rails_ba555ab61b`
FOREIGN KEY (`requirement_id`)
  REFERENCES `requirements` (`id`)
)
  ↳ db/migrate/20210422101652_create_product_requirements.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210422101652')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddContentToProduct (20210423073817)
   (1.6ms)  ALTER TABLE `products` ADD `mini_description` text
  ↳ db/migrate/20210423073817_add_content_to_product.rb:3
   (1.5ms)  ALTER TABLE `products` ADD `product_img` varchar(255)
  ↳ db/migrate/20210423073817_add_content_to_product.rb:4
   (2.1ms)  ALTER TABLE `products` ADD `product_icon` varchar(255)
  ↳ db/migrate/20210423073817_add_content_to_product.rb:5
   (2.8ms)  ALTER TABLE `products` ADD `title` varchar(255)
  ↳ db/migrate/20210423073817_add_content_to_product.rb:6
   (1.4ms)  ALTER TABLE `products` ADD `product_tags` text
  ↳ db/migrate/20210423073817_add_content_to_product.rb:7
   (1.5ms)  ALTER TABLE `products` ADD `slug` varchar(255)
  ↳ db/migrate/20210423073817_add_content_to_product.rb:8
   (1.6ms)  CREATE UNIQUE INDEX `index_products_on_slug`  ON `products` (`slug`) 
  ↳ db/migrate/20210423073817_add_content_to_product.rb:9
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210423073817')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateFriendlyIdSlugs (20210423090506)
   (2.1ms)  CREATE TABLE `friendly_id_slugs` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `slug` varchar(255) NOT NULL, `sluggable_id` int NOT NULL, `sluggable_type` varchar(50), `scope` varchar(255), `created_at` datetime)
  ↳ db/migrate/20210423090506_create_friendly_id_slugs.rb:10
   (3.0ms)  CREATE  INDEX `index_friendly_id_slugs_on_sluggable_type_and_sluggable_id`  ON `friendly_id_slugs` (`sluggable_type`, `sluggable_id`) 
  ↳ db/migrate/20210423090506_create_friendly_id_slugs.rb:17
   (2.2ms)  CREATE  INDEX `index_friendly_id_slugs_on_slug_and_sluggable_type`  ON `friendly_id_slugs` (`slug`(140), `sluggable_type`(50)) 
  ↳ db/migrate/20210423090506_create_friendly_id_slugs.rb:18
   (1.8ms)  CREATE UNIQUE INDEX `index_friendly_id_slugs_on_slug_and_sluggable_type_and_scope`  ON `friendly_id_slugs` (`slug`(70), `sluggable_type`(50), `scope`(70)) 
  ↳ db/migrate/20210423090506_create_friendly_id_slugs.rb:19
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210423090506')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddFeaturedToProduct (20210430082634)
   (5.7ms)  ALTER TABLE `products` ADD `featured` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210430082634_add_featured_to_product.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210430082634')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreatePages (20210504034638)
   (1.3ms)  CREATE TABLE `pages` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` varchar(255) NOT NULL, `title` varchar(255) NOT NULL, `description` text, `keywords` text, `active` tinyint(1) DEFAULT FALSE, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL)
  ↳ db/migrate/20210504034638_create_pages.rb:3
   (2.4ms)  CREATE UNIQUE INDEX `index_pages_on_name`  ON `pages` (`name`) 
  ↳ db/migrate/20210504034638_create_pages.rb:12
   (1.3ms)  CREATE UNIQUE INDEX `index_pages_on_title`  ON `pages` (`title`) 
  ↳ db/migrate/20210504034638_create_pages.rb:13
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210504034638')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateArticles (20210504034843)
   (1.7ms)  CREATE TABLE `articles` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `title` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `featured` tinyint(1) DEFAULT FALSE, `content` text, `article_img` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL)
  ↳ db/migrate/20210504034843_create_articles.rb:3
   (1.3ms)  CREATE UNIQUE INDEX `index_articles_on_title`  ON `articles` (`title`) 
  ↳ db/migrate/20210504034843_create_articles.rb:12
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210504034843')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddPartialToProduct (20210504100815)
   (1.5ms)  ALTER TABLE `products` ADD `form_partial` varchar(255)
  ↳ db/migrate/20210504100815_add_partial_to_product.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210504100815')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddBusinessFieldsToCustomer (20210504163605)
   (2.9ms)  ALTER TABLE `customers` ADD `phone` varchar(255)
  ↳ db/migrate/20210504163605_add_business_fields_to_customer.rb:3
   (2.1ms)  ALTER TABLE `customers` ADD `business_nature` varchar(255)
  ↳ db/migrate/20210504163605_add_business_fields_to_customer.rb:4
   (2.1ms)  ALTER TABLE `customers` ADD `trading_name` varchar(255)
  ↳ db/migrate/20210504163605_add_business_fields_to_customer.rb:5
   (3.0ms)  ALTER TABLE `customers` ADD `incorporation_date` date
  ↳ db/migrate/20210504163605_add_business_fields_to_customer.rb:6
   (1.7ms)  ALTER TABLE `customers` ADD `cr_number` varchar(255)
  ↳ db/migrate/20210504163605_add_business_fields_to_customer.rb:7
   (1.9ms)  ALTER TABLE `customers` ADD `bp_number` varchar(255)
  ↳ db/migrate/20210504163605_add_business_fields_to_customer.rb:8
   (1.8ms)  ALTER TABLE `customers` ADD `estimated_sales` decimal(18,2) DEFAULT 0.0
  ↳ db/migrate/20210504163605_add_business_fields_to_customer.rb:9
   (3.2ms)  ALTER TABLE `customers` ADD `net_profit` decimal(18,2) DEFAULT 0.0
  ↳ db/migrate/20210504163605_add_business_fields_to_customer.rb:10
   (2.0ms)  ALTER TABLE `customers` ADD `employees_number` int DEFAULT 0
  ↳ db/migrate/20210504163605_add_business_fields_to_customer.rb:11
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210504163605')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateDirectors (20210505031620)
   (1.7ms)  CREATE TABLE `directors` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `customer_id` bigint, `title` varchar(255) NOT NULL, `gender` varchar(255) NOT NULL, `firstname` varchar(255) NOT NULL, `lastname` varchar(255) NOT NULL, `maiden_name` varchar(255), `dob` date NOT NULL, `idnumber` varchar(255) NOT NULL, `marital_status` varchar(255), `nationality` varchar(255) NOT NULL, `mobile_1` varchar(255) NOT NULL, `email` varchar(255) NOT NULL, `academic_qualification` varchar(255), `address_1` varchar(255) NOT NULL, `address_2` varchar(255), `city` varchar(255) NOT NULL, `country` varchar(255) NOT NULL, `citizenship` varchar(255) NOT NULL, `spouse_name` varchar(255), `spouse_mobile` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_directors_on_customer_id`  (`customer_id`), CONSTRAINT `fk_rails_6e8c81f5d8`
FOREIGN KEY (`customer_id`)
  REFERENCES `customers` (`id`)
)
  ↳ db/migrate/20210505031620_create_directors.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210505031620')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddCalculatorToProduct (20210510203720)
   (3.2ms)  ALTER TABLE `products` ADD `requires_calculator` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210510203720_add_calculator_to_product.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210510203720')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateUserNotifications (20210531045347)
   (2.5ms)  CREATE TABLE `user_notifications` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `user_id` bigint, `message` text, `from` varchar(255), `read` tinyint(1) DEFAULT FALSE, `loan_application_id` bigint, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_user_notifications_on_user_id`  (`user_id`),  INDEX `index_user_notifications_on_loan_application_id`  (`loan_application_id`), CONSTRAINT `fk_rails_cdbff2ee9e`
FOREIGN KEY (`user_id`)
  REFERENCES `users` (`id`)
, CONSTRAINT `fk_rails_089425c514`
FOREIGN KEY (`loan_application_id`)
  REFERENCES `loan_applications` (`id`)
)
  ↳ db/migrate/20210531045347_create_user_notifications.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210531045347')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateLoanApplicationLogs (20210531132034)
   (1.1ms)  CREATE TABLE `loan_application_logs` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `loan_application_id` bigint, `status` varchar(255), `user_id` bigint, `activity` text, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_loan_application_logs_on_loan_application_id`  (`loan_application_id`),  INDEX `index_loan_application_logs_on_user_id`  (`user_id`), CONSTRAINT `fk_rails_5640cdb094`
FOREIGN KEY (`loan_application_id`)
  REFERENCES `loan_applications` (`id`)
, CONSTRAINT `fk_rails_125fd77054`
FOREIGN KEY (`user_id`)
  REFERENCES `users` (`id`)
)
  ↳ db/migrate/20210531132034_create_loan_application_logs.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210531132034')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateActiveStorageTables (20210601081055)
   (1.2ms)  CREATE TABLE `active_storage_blobs` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `key` varchar(255) NOT NULL, `filename` varchar(255) NOT NULL, `content_type` varchar(255), `metadata` text, `byte_size` bigint NOT NULL, `checksum` varchar(255) NOT NULL, `created_at` datetime NOT NULL, UNIQUE INDEX `index_active_storage_blobs_on_key`  (`key`))
  ↳ db/migrate/20210601081055_create_active_storage_tables.active_storage.rb:4
   (1.1ms)  CREATE TABLE `active_storage_attachments` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `name` varchar(255) NOT NULL, `record_type` varchar(255) NOT NULL, `record_id` bigint NOT NULL, `blob_id` bigint NOT NULL, `created_at` datetime NOT NULL,  INDEX `index_active_storage_attachments_on_blob_id`  (`blob_id`), UNIQUE INDEX `index_active_storage_attachments_uniqueness`  (`record_type`, `record_id`, `name`, `blob_id`), CONSTRAINT `fk_rails_c3b3935057`
FOREIGN KEY (`blob_id`)
  REFERENCES `active_storage_blobs` (`id`)
)
  ↳ db/migrate/20210601081055_create_active_storage_tables.active_storage.rb:16
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210601081055')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddCurrencyToLoanApplication (20210601103811)
   (1.7ms)  ALTER TABLE `loan_applications` ADD `currency_id` bigint
  ↳ db/migrate/20210601103811_add_currency_to_loan_application.rb:3
   (2.3ms)  CREATE  INDEX `index_loan_applications_on_currency_id`  ON `loan_applications` (`currency_id`) 
  ↳ db/migrate/20210601103811_add_currency_to_loan_application.rb:3
   (1.6ms)  ALTER TABLE `loan_applications` ADD CONSTRAINT `fk_rails_63c49459c8`
FOREIGN KEY (`currency_id`)
  REFERENCES `currencies` (`id`)

  ↳ db/migrate/20210601103811_add_currency_to_loan_application.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210601103811')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreatePledgedSecurities (20210603234344)
   (1.2ms)  CREATE TABLE `pledged_securities` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `loan_application_id` bigint, `security_type` varchar(255) NOT NULL, `description` varchar(255) NOT NULL, `estimated_value` decimal(18,2) DEFAULT 0.0, `serial_number` varchar(255), `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_pledged_securities_on_loan_application_id`  (`loan_application_id`), CONSTRAINT `fk_rails_e8a1a8cf81`
FOREIGN KEY (`loan_application_id`)
  REFERENCES `loan_applications` (`id`)
)
  ↳ db/migrate/20210603234344_create_pledged_securities.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210603234344')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddIsAttachmentToRequirement (20210607164130)
   (2.8ms)  ALTER TABLE `requirements` ADD `is_attachment` tinyint(1) DEFAULT TRUE
  ↳ db/migrate/20210607164130_add_is_attachment_to_requirement.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210607164130')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddActiveToCurrency (20210608062606)
   (1.5ms)  ALTER TABLE `currencies` ADD `active` tinyint(1) DEFAULT TRUE
  ↳ db/migrate/20210608062606_add_active_to_currency.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210608062606')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddValidatorsToLoanApplication (20210610214754)
   (1.7ms)  ALTER TABLE `loan_applications` ADD `personal_details` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210610214754_add_validators_to_loan_application.rb:3
   (2.1ms)  ALTER TABLE `loan_applications` ADD `contact_details` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210610214754_add_validators_to_loan_application.rb:4
   (2.4ms)  ALTER TABLE `loan_applications` ADD `employer_details` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210610214754_add_validators_to_loan_application.rb:5
   (3.9ms)  ALTER TABLE `loan_applications` ADD `attachments` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210610214754_add_validators_to_loan_application.rb:6
   (1.8ms)  ALTER TABLE `loan_applications` ADD `directors_details` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210610214754_add_validators_to_loan_application.rb:7
   (5.6ms)  ALTER TABLE `loan_applications` ADD `banker_details` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210610214754_add_validators_to_loan_application.rb:8
   (1.6ms)  ALTER TABLE `loan_applications` ADD `next_of_kin_details` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210610214754_add_validators_to_loan_application.rb:9
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210610214754')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddAgreeToLoanApplication (20210611123954)
   (1.7ms)  ALTER TABLE `loan_applications` ADD `agree_to_terms` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210611123954_add_agree_to_loan_application.rb:3
   (3.2ms)  ALTER TABLE `loan_applications` ADD `privacy_policy` tinyint(1) DEFAULT FALSE
  ↳ db/migrate/20210611123954_add_agree_to_loan_application.rb:4
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210611123954')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to AddLoanPurposeToProduct (20210611144659)
   (2.0ms)  ALTER TABLE `products` ADD `loan_purpose_id` int
  ↳ db/migrate/20210611144659_add_loan_purpose_to_product.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.1ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210611144659')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
Migrating to CreateLoanAccounts (20210621163418)
   (1.3ms)  CREATE TABLE `loan_accounts` (`id` bigint NOT NULL AUTO_INCREMENT PRIMARY KEY, `user_id` bigint, `account_number` varchar(255), `customer_account_id` int, `account_name` varchar(255), `last_updated_on` datetime, `created_at` datetime NOT NULL, `updated_at` datetime NOT NULL,  INDEX `index_loan_accounts_on_user_id`  (`user_id`), CONSTRAINT `fk_rails_6067ce23a9`
FOREIGN KEY (`user_id`)
  REFERENCES `users` (`id`)
)
  ↳ db/migrate/20210621163418_create_loan_accounts.rb:3
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::SchemaMigration Create (0.2ms)  INSERT INTO `schema_migrations` (`version`) VALUES ('20210621163418')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
  ActiveRecord::InternalMetadata Load (0.2ms)  SELECT  `ar_internal_metadata`.* FROM `ar_internal_metadata` WHERE `ar_internal_metadata`.`key` = 'environment' LIMIT 1
  ↳ bin/rails:4
   (0.1ms)  BEGIN
  ↳ bin/rails:4
  ActiveRecord::InternalMetadata Create (0.2ms)  INSERT INTO `ar_internal_metadata` (`key`, `value`, `created_at`, `updated_at`) VALUES ('environment', 'development', '2023-11-18 07:32:53', '2023-11-18 07:32:53')
  ↳ bin/rails:4
   (0.1ms)  COMMIT
  ↳ bin/rails:4
   (0.1ms)  SELECT RELEASE_LOCK('5819118608264770620')
  ↳ bin/rails:4
   (0.2ms)  SELECT `schema_migrations`.`version` FROM `schema_migrations` ORDER BY `schema_migrations`.`version` ASC
  ↳ bin/rails:4