One Hat Cyber Team

Edit File: sess_f610e850686e5a5a01f0de7d243687b1

PMA_token |s:32:"5e5c4f674f22596454552d423074335c"; HMAC_secret |s:16:"s[tL~\C.^(h;w@$2";auth_type|s:3:"env";browser_access_time|a:1:{s:7:"default";i:1767126031;}encryption_key|s:32:"���pS�[�C�+��)�ps����k۞�&�";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:1767126006;}two_factor_check|b:1;cache|a:3:{s:8:"server_1";a:4:{s:15:"userprefs_mtime";i:1767126006;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_faaz4tfn5q";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:18:"farmersapp\_church";i:1;s:17:"farmersapp\_loans";i:2;s:16:"farmersapp\_data";i:3;s:16:"farmersapp\_loan";}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_faaz4tfn5q@localhost";s:12:"is_superuser";b:0;s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;}s:19:"server_1_farmersapp";a:18:{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:16:"farmersapp\_data";i:2;s:17:"farmersapp\_loans";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: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: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:19:"profiling_supported";b:1;s:17:"menu-levels-table";a:11:{s:6:"browse";s:6:"Browse";s:9:"structure";s:9:"Structure";s:3:"sql";s:3:"SQL";s:6:"search";s:6:"Search";s:6:"insert";s:6:"Insert";s:6:"export";s:6:"Export";s:6:"import";s:6:"Import";s:10:"privileges";s:10:"Privileges";s:9:"operation";s:10:"Operations";s:8:"tracking";s:8:"Tracking";s:8:"triggers";s:8:"Triggers";}s:12:"is_superuser";b:0;s:14:"mysql_cur_user";s:20:"farmersapp@localhost";s:12:"is_grantuser";b:0;s:13:"is_createuser";b:0;}}tmpval|a:16:{s:14:"favoriteTables";a:1:{i:1;a:0:{}}s:12:"recentTables";a:1:{i:1;a:1:{i:0;a:2:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:5:"users";}}}s:5:"query";a:10:{s:32:"e58aaef1aa793f1eafb4927ab45f2af0";a:8:{s:3:"sql";s:857:"-- Table: collateral
CREATE TABLE `collateral` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `loan_id` INT NOT NULL,
  `type` VARCHAR(100) NOT NULL,
  `description` TEXT,
  `value` DECIMAL(15,2) NOT NULL,
  `owner_name` VARCHAR(100),
  `owner_contact` VARCHAR(20),
  `document_number` VARCHAR(100),
  `document_type` VARCHAR(50),
  `document_file` VARCHAR(255),
  `location` VARCHAR(255),
  `condition` ENUM('excellent', 'good', 'fair', 'poor') DEFAULT 'good',
  `status` ENUM('active', 'released', 'seized', 'sold') DEFAULT 'active',
  `release_date` DATE,
  `release_notes` TEXT,
  `created_by` INT,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX `idx_loan` (`loan_id`),
  INDEX `idx_status` (`status`)
) 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:"8a2c6d26f3b66f1d975ee5c8224e1a4a";a:8:{s:3:"sql";s:581:"-- Table: settings
CREATE TABLE `settings` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `setting_key` VARCHAR(100) UNIQUE NOT NULL,
  `setting_value` TEXT,
  `setting_group` VARCHAR(50) DEFAULT 'general',
  `is_public` BOOLEAN DEFAULT FALSE,
  `data_type` ENUM('string', 'integer', 'decimal', 'boolean', 'array', 'json') DEFAULT 'string',
  `description` TEXT,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX `idx_group` (`setting_group`)
) 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:"4bb5e367618c70b059eda2892e0a83dd";a:8:{s:3:"sql";s:809:"-- Insert default settings
INSERT INTO `settings` (`setting_key`, `setting_value`, `setting_group`, `is_public`, `data_type`) VALUES
('company_name', 'Farmers Loan Management System', 'general', TRUE, 'string'),
('company_address', 'Blantyre, Malawi', 'general', TRUE, 'string'),
('company_phone', '+265 123 456 789', 'general', TRUE, 'string'),
('company_email', 'info@farmersloan.com', 'general', TRUE, 'string'),
('currency', 'MWK', 'general', TRUE, 'string'),
('currency_symbol', 'MK', 'general', TRUE, 'string'),
('date_format', 'd/m/Y', 'general', TRUE, 'string'),
('time_format', 'H:i:s', 'general', TRUE, 'string'),
('timezone', 'Africa/Blantyre', 'general', TRUE, 'string'),
('loan_number_prefix', 'LOAN', 'loans', FALSE, 'string'),
('loan_number_length', '8', 'loans', FALSE, 'integer');";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:"c7184961b07d7b713e42fef9e40afacf";a:8:{s:3:"sql";s:179:"-- Insert default branch
INSERT INTO `branches` (`name`, `code`, `city`, `country`, `currency`, `status`) VALUES
('Main Branch', 'BR001', 'Blantyre', 'Malawi', 'MWK', 'active');";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:"b48f8eb796591b96c3689b1b9c1d29e6";a:8:{s:3:"sql";s:527:"-- Insert default admin user (password: Admin@123)
INSERT INTO `users` (`username`, `email`, `password`, `first_name`, `last_name`, `role`, `status`, `permissions`) VALUES
('admin', 'admin@farmersloan.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'System', 'Administrator', 'admin', 'active', '{"all": true}'),
('borrower', 'borrower@farmersloan.com', '$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'John', 'Doe', 'borrower', 'active', '{"view_loans": true, "make_payments": true}');";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:"5a2e99f915a48f2e41188d66b39e09d1";a:8:{s:3:"sql";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');";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:"a0142e3586927516de2dccb29045a071";a:8:{s:3:"sql";s:242:"-- Farmers Loan Management System Database Schema
-- Run this in phpMyAdmin SQL tab or MySQL command line

-- 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:"920f352cc0e066cb1ac425a58fcdf7d5";a:8:{s:3:"sql";s:1091:"-- 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',
  `branch_id` INT DEFAULT 1,
  `phone` VARCHAR(20),
  `address` TEXT,
  `city` VARCHAR(50),
  `state` VARCHAR(50),
  `country` VARCHAR(50) DEFAULT 'Malawi',
  `profile_image` VARCHAR(255),
  `status` ENUM('active', 'inactive', 'suspended') DEFAULT 'active',
  `permissions` TEXT COMMENT 'JSON encoded permissions',
  `last_login` DATETIME,
  `login_attempts` INT DEFAULT 0,
  `locked_until` DATETIME,
  `reset_token` VARCHAR(100),
  `reset_expiry` DATETIME,
  `created_by` INT,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX `idx_role` (`role`),
  INDEX `idx_branch` (`branch_id`),
  INDEX `idx_status` (`status`)
) 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:"3af6b242d7dfa0ec2c2b844985d3d21c";a:8:{s:3:"sql";s:21:"SELECT * FROM `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: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";s:20:"possible_as_geometry";b:1;s:13:"table_uiprefs";a:1:{i:1;a:1:{s:16:"farmersapp_loans";a:1:{s:5:"users";a:0:{}}}}}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:{}sql_history|a:5:{i:0;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:160:"DROP TABLE `audit_log`, `borrowers`, `branches`, `collateral`, `loans`, `loan_products`, `loan_schedule`, `plugins`, `repayments`, `roles`, `settings`, `users`;";}i:1;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:58:"DROP TABLE `borrowers`, `loans`, `loan_products`, `users`;";}i:2;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:0:"";s:8:"sqlquery";s:124:"DROP TABLE `borrowers`, `branches`, `loans`, `loan_products`, `loan_schedule`, `plugins`, `repayments`, `settings`, `users`;";}i:3;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:4;a:3:{s:2:"db";s:16:"farmersapp_loans";s:5:"table";s:5:"users";s:8:"sqlquery";s:21:"SELECT * FROM `users`";}}Import_message|a:2:{s:7:"message";s:2743:"<div class="alert alert-danger" role="alert"><h1>Error</h1><p><strong>SQL query:</strong>  <a href="#" class="copyQueryBtn" data-text="-- 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(&#039;admin&#039;, &#039;staff&#039;, &#039;borrower&#039;) DEFAULT &#039;borrower&#039;,
  `branch_id` INT DEFAULT 1,
  `phone` VARCHAR(20),
  `address` TEXT,
  `city` VARCHAR(50),
  `state` VARCHAR(50),
  `country` VARCHAR(50) DEFAULT &#039;Malawi&#039;,
  `profile_image` VARCHAR(255),
  `status` ENUM(&#039;active&#039;, &#039;inactive&#039;, &#039;suspended&#039;) DEFAULT &#039;active&#039;,
  `permissions` TEXT COMMENT &#039;JSON encoded permissions&#039;,
  `last_login` DATETIME,
  `login_attempts` INT DEFAULT 0,
  `locked_until` DATETIME,
  `reset_token` VARCHAR(100),
  `reset_expiry` DATETIME,
  `created_by` INT,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX `idx_role` (`role`),
  INDEX `idx_branch` (`branch_id`),
  INDEX `idx_status` (`status`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;">Copy</a>
    </p>
<p>
<code class="sql" dir="ltr"><pre>
-- 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',
  `branch_id` INT DEFAULT 1,
  `phone` VARCHAR(20),
  `address` TEXT,
  `city` VARCHAR(50),
  `state` VARCHAR(50),
  `country` VARCHAR(50) DEFAULT 'Malawi',
  `profile_image` VARCHAR(255),
  `status` ENUM('active', 'inactive', 'suspended') DEFAULT 'active',
  `permissions` TEXT COMMENT 'JSON encoded permissions',
  `last_login` DATETIME,
  `login_attempts` INT DEFAULT 0,
  `locked_until` DATETIME,
  `reset_token` VARCHAR(100),
  `reset_expiry` DATETIME,
  `created_by` INT,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  INDEX `idx_role` (`role`),
  INDEX `idx_branch[...]
</pre></code>
</p>
<p>
    <strong>MySQL said: </strong><a href="./url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fserver-error-reference.html" target="mysql_doc"><img src="themes/dot.gif" title="Documentation" alt="Documentation" class="icon ic_b_help"></a>
</p>
<code>#1050 - Table &#039;users&#039; already exists</code><br></div>";s:11:"go_back_url";s:55:"index.php?route=/database/structure&db=farmersapp_loans";}is_multi_query|b:0;errors|a:0:{}