One Hat Cyber Team

Edit File: sess_04bdb03a20fddaf789230021a3f29b0e

PMA_token |s:32:"754147744643776c4775665d54424e6a"; HMAC_secret |s:16:"%;~20`zOxm(Sue)c";auth_type|s:3:"env";browser_access_time|a:2:{s:7:"default";i:1767132223;s:36:"46c4ed63-a3c4-0ff4-cb15-c3e5b25031f0";i:1767130053;}encryption_key|s:32:"R��ՊB�w"�L��{�T�y�}������%��f";relation|a:1:{i:1;a:41:{s:7:"version";s:5:"5.2.2";s:4:"user";N;s:2:"db";N;s:8:"bookmark";N;s:15:"central_columns";N;s:11:"column_info";N;s:17:"designer_settings";N;s:16:"export_templates";N;s:8:"favorite";N;s:7:"history";N;s:16:"navigationhiding";N;s:9:"pdf_pages";N;s:6:"recent";N;s:8:"relation";N;s:13:"savedsearches";N;s:12:"table_coords";N;s:10:"table_info";N;s:13:"table_uiprefs";N;s:8:"tracking";N;s:10:"userconfig";N;s:10:"usergroups";N;s:5:"users";N;s:12:"bookmarkwork";b:0;s:8:"mimework";b:0;s:18:"centralcolumnswork";b:0;s:8:"commwork";b:0;s:9:"menuswork";b:0;s:20:"designersettingswork";b:0;s:11:"displaywork";b:0;s:19:"exporttemplateswork";b:0;s:12:"favoritework";b:0;s:7:"navwork";b:0;s:7:"pdfwork";b:0;s:10:"recentwork";b:0;s:7:"relwork";b:0;s:17:"savedsearcheswork";b:0;s:11:"historywork";b:0;s:12:"trackingwork";b:0;s:11:"uiprefswork";b:0;s:14:"userconfigwork";b:0;s:8:"allworks";b:0;}}userconfig|a:2:{s:2:"db";a:1:{s:12:"Console/Mode";s:8:"collapse";}s:2:"ts";i:1767132210;}two_factor_check|b:1;cache|a:2:{s:8:"server_1";a:4:{s:15:"userprefs_mtime";i:1767132210;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1748677935;s:9:"userprefs";a:1:{s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}}}s:25:"server_1_cpses_famo94ku9j";a:16:{s:17:"is_create_db_priv";b:0;s:14:"is_reload_priv";b:0;s:12:"db_to_create";s:0:"";s:30:"dbs_where_create_table_allowed";a:4:{i:0;s:16:"farmersapp\_loan";i:1;s:17:"farmersapp\_loans";i:2;s:16:"farmersapp\_data";i:3;s:18:"farmersapp\_church";}s:11:"dbs_to_test";b:0;s:9:"proc_priv";b:0;s:10:"table_priv";b:0;s:8:"col_priv";b:0;s:7:"db_priv";b:0;s:11:"binary_logs";a:0:{}s:18:"menu-levels-server";a:13:{s:9:"databases";s:9:"Databases";s:3:"sql";s:3:"SQL";s:6:"status";s:6:"Status";s:6:"rights";s:5:"Users";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:8:"settings";s:8:"Settings";s:6:"binlog";s:10:"Binary log";s:11:"replication";s:11:"Replication";s:4:"vars";s:9:"Variables";s:7:"charset";s:8:"Charsets";s:7:"plugins";s:7:"Plugins";s:6:"engine";s:7:"Engines";}s:14:"menu-levels-db";a:14:{s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Search";s:5:"query";s:5:"Query";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:9:"operation";s:10:"Operations";s:10:"privileges";s:10:"Privileges";s:8:"routines";s:8:"Routines";s:6:"events";s:6:"Events";s:8:"triggers";s:8:"Triggers";s:8:"tracking";s:8:"Tracking";s:8:"designer";s:8:"Designer";s:15:"central_columns";s:15:"Central columns";}s:14:"mysql_cur_user";s:26:"cpses_famo94ku9j@localhost";s:12:"is_superuser";b:0;s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;}}tmpval|a:14:{s:14:"favoriteTables";a:1:{i:1;a:0:{}}s:12:"recentTables";a:1:{i:1;a:0:{}}s:5:"query";a:10:{s:32:"99adc23ee3c4579a348b829d9264738f";a:8:{s:3:"sql";s:32:"DROP TABLE IF EXISTS `branches`;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"ba0059ff0201d67ecddb698de94f8c6c";a:8:{s:3:"sql";s:29:"DROP TABLE IF EXISTS `users`;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"777817038d3858e009089d53b0dcd54d";a:8:{s:3:"sql";s:132:"-- Create database if not exists
CREATE DATABASE IF NOT EXISTS `farmersapp_loans` CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"fa2e3bdf9315e34c5e28901ac764ec17";a:8:{s:3:"sql";s:23:"USE `farmersapp_loans`;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"a71966f552774bdbeb9dcc13d4c22a05";a:8:{s:3:"sql";s:473:"-- Table: users
CREATE TABLE `users` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `username` VARCHAR(50) UNIQUE NOT NULL,
  `email` VARCHAR(100) UNIQUE NOT NULL,
  `password` VARCHAR(255) NOT NULL,
  `first_name` VARCHAR(50),
  `last_name` VARCHAR(50),
  `role` ENUM('admin', 'staff', 'borrower') DEFAULT 'borrower',
  `status` ENUM('active', 'inactive') DEFAULT 'active',
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"da0fdf0e4d06f57213b7c35333b24f05";a:8:{s:3:"sql";s:415:"-- Table: branches
CREATE TABLE `branches` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `name` VARCHAR(100) NOT NULL,
  `code` VARCHAR(20) UNIQUE NOT NULL,
  `city` VARCHAR(50),
  `country` VARCHAR(50) DEFAULT 'Malawi',
  `currency` VARCHAR(10) DEFAULT 'MWK',
  `status` ENUM('active', 'inactive') DEFAULT 'active',
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"ffcdeab62819b294ac729bf2b356afba";a:8:{s:3:"sql";s:460:"-- Table: borrowers
CREATE TABLE `borrowers` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `first_name` VARCHAR(50),
  `last_name` VARCHAR(50),
  `mobile` VARCHAR(20),
  `email` VARCHAR(100),
  `address` TEXT,
  `city` VARCHAR(50),
  `country` VARCHAR(50) DEFAULT 'Malawi',
  `status` ENUM('active', 'inactive') DEFAULT 'active',
  `branch_id` INT DEFAULT 1,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"4d28aee2714c20f851b64bfe182e8466";a:8:{s:3:"sql";s:589:"-- Table: loans
CREATE TABLE `loans` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `loan_number` VARCHAR(50) UNIQUE NOT NULL,
  `borrower_id` INT NOT NULL,
  `principal_amount` DECIMAL(15,2) NOT NULL,
  `interest_rate` DECIMAL(5,2) NOT NULL,
  `duration` INT NOT NULL,
  `total_amount` DECIMAL(15,2) NOT NULL,
  `released_date` DATE,
  `maturity_date` DATE,
  `status` ENUM('processing', 'approved', 'active', 'completed', 'defaulted') DEFAULT 'processing',
  `branch_id` INT DEFAULT 1,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"52fb65df94475ca0b1a0d23a536e25a6";a:8:{s:3:"sql";s:159:"-- Insert default branch
INSERT INTO `branches` (`name`, `code`, `city`, `country`, `currency`) VALUES
('Main Branch', 'BR001', 'Blantyre', 'Malawi', 'MWK');";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}s:32:"6e2dbd1d6e77daed3b8ef9651022a069";a:8:{s:3:"sql";s:400:"-- Insert users with simple passwords (we'll fix this in PHP)
INSERT INTO `users` (`username`, `email`, `password`, `first_name`, `last_name`, `role`) VALUES
('admin', 'admin@farmersloan.com', 'admin123', 'System', 'Admin', 'admin'),
('staff', 'staff@farmersloan.com', 'staff123', 'John', 'Staff', 'staff'),
('borrower', 'borrower@farmersloan.com', 'borrower123', 'Jane', 'Borrower', 'borrower');";s:12:"repeat_cells";i:100;s:8:"max_rows";i:25;s:3:"pos";i:0;s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;}}s:6:"pftext";s:1:"P";s:18:"relational_display";s:1:"K";s:9:"geoOption";s:4:"GEOM";s:14:"display_binary";b:1;s:12:"display_blob";b:0;s:19:"hide_transformation";b:0;s:3:"pos";i:0;s:8:"max_rows";i:25;s:12:"repeat_cells";i:100;s:18:"table_limit_offset";i:0;s:21:"table_limit_offset_db";s:16:"farmersapp_loans";}git_location|N;is_git_revision|b:0;ConfigFile1|a:4:{s:28:"PmaNoRelation_DisableWarning";b:1;s:12:"ShowCreateDb";b:0;s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}s:7:"Servers";a:1:{i:1;a:2:{s:7:"only_db";s:0:"";s:7:"hide_db";s:0:"";}}}debug|a:0:{}flashMessages|a:0:{}Import_message|a:2:{s:7:"message";N;s:11:"go_back_url";s:55:"index.php?route=/database/structure&db=farmersapp_loans";}is_multi_query|b:1;sql_from_query_box|b:1;sql_history|a:11:{i:0;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:700:"-- Insert sample loan products
INSERT INTO `loan_products` (`name`, `code`, `description`, `product_type`, `min_amount`, `max_amount`, `interest_rate`, `interest_type`, `duration`, `duration_type`, `repayment_cycle`, `status`) VALUES
('Agricultural Loan', 'AGR-001', 'Loan for agricultural activities', 'agriculture', 100000.00, 5000000.00, 12.00, 'flat', 12, 'months', 'monthly', 'active'),
('Small Business Loan', 'SBL-001', 'Loan for small business expansion', 'business', 50000.00, 2000000.00, 15.00, 'reducing', 24, 'months', 'monthly', 'active'),
('Emergency Loan', 'EMG-001', 'Quick loan for emergencies', 'emergency', 10000.00, 500000.00, 18.00, 'flat', 6, 'months', 'monthly', 'active');";}i:1;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:138:"DROP TABLE `borrowers`, `branches`, `collateral`, `loans`, `loan_products`, `loan_schedule`, `plugins`, `repayments`, `settings`, `users`;";}i:2;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:700:"-- Insert sample loan products
INSERT INTO `loan_products` (`name`, `code`, `description`, `product_type`, `min_amount`, `max_amount`, `interest_rate`, `interest_type`, `duration`, `duration_type`, `repayment_cycle`, `status`) VALUES
('Agricultural Loan', 'AGR-001', 'Loan for agricultural activities', 'agriculture', 100000.00, 5000000.00, 12.00, 'flat', 12, 'months', 'monthly', 'active'),
('Small Business Loan', 'SBL-001', 'Loan for small business expansion', 'business', 50000.00, 2000000.00, 15.00, 'reducing', 24, 'months', 'monthly', 'active'),
('Emergency Loan', 'EMG-001', 'Quick loan for emergencies', 'emergency', 10000.00, 500000.00, 18.00, 'flat', 6, 'months', 'monthly', 'active');";}i:3;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:400:"-- Insert users with simple passwords (we'll fix this in PHP)
INSERT INTO `users` (`username`, `email`, `password`, `first_name`, `last_name`, `role`) VALUES
('admin', 'admin@farmersloan.com', 'admin123', 'System', 'Admin', 'admin'),
('staff', 'staff@farmersloan.com', 'staff123', 'John', 'Staff', 'staff'),
('borrower', 'borrower@farmersloan.com', 'borrower123', 'Jane', 'Borrower', 'borrower');";}i:4;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:138:"DROP TABLE `borrowers`, `branches`, `collateral`, `loans`, `loan_products`, `loan_schedule`, `plugins`, `repayments`, `settings`, `users`;";}i:5;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:162:"DROP TABLE `borrowers`, `borrower_groups`, `branches`, `fees`, `loans`, `loan_fees`, `loan_products`, `loan_schedule`, `repayments`, `roles_permissions`, `users`;";}i:6;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:162:"DROP TABLE `borrowers`, `borrower_groups`, `branches`, `fees`, `loans`, `loan_fees`, `loan_products`, `loan_schedule`, `repayments`, `roles_permissions`, `users`;";}i:7;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:95:"DROP TABLE `borrowers`, `branches`, `fees`, `loans`, `loan_products`, `loan_schedule`, `users`;";}i:8;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:70:"DROP TABLE `borrowers`, `branches`, `loans`, `loan_products`, `users`;";}i:9;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:334:"DROP TABLE `bank_accounts`, `borrowers`, `borrower_groups`, `branches`, `chart_of_accounts`, `collateral`, `fees`, `guarantors`, `journal_entries`, `journal_entry_lines`, `loans`, `loan_fees`, `loan_products`, `loan_schedule`, `repayments`, `roles_permissions`, `savings_accounts`, `savings_products`, `savings_transactions`, `users`;";}i:10;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:175:"DROP TABLE `borrowers`, `branches`, `chart_of_accounts`, `fees`, `journal_entries`, `loans`, `loan_products`, `loan_schedule`, `savings_accounts`, `savings_products`, `users`;";}}errors|a:0:{}