0xn0l

📂 /home/brightbrai/tmp

✎ EDIT: sess_c2fcdee94505e5c555ce8eb14db73c0c ← BACK

PMA_token |s:32:"505030627d70534c355f363a7e572170"; HMAC_secret |s:16:"G-)^SG>:=w}iyJJ+";auth_type|s:3:"env";browser_access_time|a:1:{s:7:"default";i:1785213943;}encryption_key|s:32:"2y��h��3 ��2��t_�f���l��PEU";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:1785213943;}two_factor_check|b:1;cache|a:2:{s:8:"server_1";a:3:{s:15:"userprefs_mtime";i:1785213932;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1778012714;}s:19:"server_1_brightbrai";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:38:{i:0;s:22:"brightbrai\_abdulmalik";i:1;s:18:"brightbrai\_sas123";i:2;s:14:"brightbrai\_CM";i:3;s:17:"brightbrai\_wp384";i:4;s:21:"brightbrai\_academydb";i:5;s:20:"brightbrai\_newfajar";i:6;s:16:"brightbrai\_SMCS";i:7;s:25:"brightbrai\_sorbitacademy";i:8;s:16:"brightbrai\_test";i:9;s:17:"brightbrai\_store";i:10;s:19:"brightbrai\_academy";i:11;s:27:"brightbrai\_brightbrai\_SMS";i:12;s:15:"brightbrai\_SMS";i:13;s:19:"brightbrai\_newmart";i:14;s:16:"brightbrai\_spps";i:15;s:17:"brightbrai\_sindh";i:16;s:22:"brightbrai\_darsequran";i:17;s:20:"brightbrai\_contacts";i:18;s:18:"brightbrai\_school";i:19;s:25:"brightbrai\_SchoolProject";i:20;s:17:"brightbrai\_wp347";i:21;s:23:"brightbrai\_electronics";i:22;s:19:"brightbrai\_wp66409";i:23;s:18:"brightbrai\_newsmc";i:24;s:18:"brightbrai\_emart2";i:25;s:17:"brightbrai\_smart";i:26;s:14:"brightbrai\_ss";i:27;s:27:"brightbrai\_instagram.login";i:28;s:19:"brightbrai\_student";i:29;s:19:"brightbrai\_expense";i:30;s:17:"brightbrai\_emart";i:31;s:20:"brightbrai\_hospital";i:32;s:20:"brightbrai\_students";i:33;s:16:"brightbrai\_SMSS";i:34;s:18:"brightbrai\_income";i:35;s:17:"brightbrai\_wp876";i:36;s:19:"brightbrai\_sample1";i:37;s:17:"brightbrai\_wp272";}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:12:"is_superuser";b:0;s:14:"mysql_cur_user";s:20:"brightbrai@localhost";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:"26e509508e61d5c5d5edbdd1505c649f";a:8:{s:3:"sql";s:510:"CREATE TABLE `bank_transactions` (
  `id` BIGINT AUTO_INCREMENT PRIMARY KEY,
  `bank_account_id` INT NOT NULL,
  `transaction_date` DATE NOT NULL,
  `transaction_type` ENUM('DEPOSIT', 'WITHDRAWAL', 'TRANSFER') NOT NULL,
  `amount` DECIMAL(12,2) NOT NULL,
  `reference_no` VARCHAR(100) NULL,
  `description` VARCHAR(255) NOT NULL,
  `is_reconciled` TINYINT(1) DEFAULT 0,
  `reconciled_at` DATETIME NULL,
  FOREIGN KEY (`bank_account_id`) REFERENCES `bank_accounts`(`id`)
) 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:"535a4928230582449ac36e9a81918a2d";a:8:{s:3:"sql";s:240:"-- -----------------------------------------------------------------------------------------
-- 9. PAYROLL MODULE
-- -----------------------------------------------------------------------------------------
DROP TABLE IF EXISTS `employees`;";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:"d429209d41e948715e76814c3d85f0b9";a:8:{s:3:"sql";s:533:"CREATE TABLE `employees` (
  `id` BIGINT AUTO_INCREMENT PRIMARY KEY,
  `employee_code` VARCHAR(20) NOT NULL UNIQUE,
  `name` VARCHAR(100) NOT NULL,
  `designation` VARCHAR(50) NOT NULL,
  `department` VARCHAR(50) NOT NULL,
  `join_date` DATE NOT NULL,
  `basic_salary` DECIMAL(12,2) NOT NULL,
  `allowances` DECIMAL(12,2) DEFAULT 0.00,
  `tax_deduction` DECIMAL(12,2) DEFAULT 0.00,
  `bank_account_number` VARCHAR(50) NULL,
  `status` ENUM('ACTIVE', 'RESIGNED', 'TERMINATED') DEFAULT 'ACTIVE'
) 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:"3ec85dee9d22ab4c260125a98dd22736";a:8:{s:3:"sql";s:36:"DROP TABLE IF EXISTS `payroll_runs`;";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:"8a8fb478b5167ab9e7a901fcb14c796f";a:8:{s:3:"sql";s:586:"CREATE TABLE `payroll_runs` (
  `id` BIGINT AUTO_INCREMENT PRIMARY KEY,
  `month_year` VARCHAR(20) NOT NULL,
  `total_gross` DECIMAL(15,2) NOT NULL,
  `total_deductions` DECIMAL(15,2) NOT NULL,
  `total_net` DECIMAL(15,2) NOT NULL,
  `status` ENUM('DRAFT', 'APPROVED', 'POSTED') DEFAULT 'POSTED',
  `journal_entry_id` BIGINT NULL,
  `processed_by` BIGINT NOT NULL,
  `processed_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (`journal_entry_id`) REFERENCES `journal_entries`(`id`),
  FOREIGN KEY (`processed_by`) REFERENCES `users`(`id`)
) 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:"d1db265cc3cd46a7d279e88f722f8d76";a:8:{s:3:"sql";s:249:"-- -----------------------------------------------------------------------------------------
-- 10. IMMUTABLE AUDIT TRAIL
-- -----------------------------------------------------------------------------------------
DROP TABLE IF EXISTS `audit_logs`;";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:"892dbdffbb7cc915cb725b14585ae163";a:8:{s:3:"sql";s:605:"CREATE TABLE `audit_logs` (
  `id` BIGINT AUTO_INCREMENT PRIMARY KEY,
  `user_id` BIGINT NULL,
  `user_name` VARCHAR(100) NOT NULL,
  `role_name` VARCHAR(50) NOT NULL,
  `action` VARCHAR(50) NOT NULL,
  `module` VARCHAR(50) NOT NULL,
  `entity_name` VARCHAR(50) NOT NULL,
  `entity_id` VARCHAR(50) NOT NULL,
  `old_values` JSON NULL,
  `new_values` JSON NULL,
  `ip_address` VARCHAR(45) NOT NULL,
  `user_agent` VARCHAR(255) NULL,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  INDEX `idx_audit_module` (`module`),
  INDEX `idx_audit_created` (`created_at`)
) 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:"4185228b22cce4365c77ad181a17f431";a:8:{s:3:"sql";s:27:"SET FOREIGN_KEY_CHECKS = 1;";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:"4295291feed8a9976e159ceaf7fa3942";a:8:{s:3:"sql";s:1141:"-- =========================================================================================
-- SEED DATA: CHART OF ACCOUNTS & INITIAL RECORDS
-- =========================================================================================

-- Roles
INSERT INTO `roles` (`id`, `name`, `code`, `permissions`) VALUES
(1, 'Super Admin', 'SUPER_ADMIN', '["*"]'),
(2, 'Administrator', 'ADMINISTRATOR', '["dashboard.*", "students.*", "fees.*", "invoices.*", "payments.*", "accounting.*", "reports.*", "payroll.*", "bank.*", "expense.*"]'),
(3, 'Finance Manager', 'FINANCE_MANAGER', '["dashboard.*", "invoices.*", "payments.*", "accounting.*", "reports.*", "payroll.*", "bank.*", "expense.*"]'),
(4, 'Accountant', 'ACCOUNTANT', '["dashboard.*", "invoices.*", "payments.*", "accounting.view", "accounting.entry", "reports.view", "expense.*"]'),
(5, 'Fee Collection Officer', 'FEE_OFFICER', '["dashboard.view", "students.view", "invoices.view", "payments.create", "payments.view"]'),
(6, 'Auditor (Read Only)', 'AUDITOR', '["*.view", "reports.export", "audit.view"]'),
(7, 'Principal', 'PRINCIPAL', '["dashboard.view", "students.view", "reports.view"]');";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:"b8c73ebe6c676587691bbecaf54381bd";a:8:{s:3:"sql";s:2658:"-- Standard Double Entry Chart of Accounts (IFRS Compliant)
INSERT INTO `chart_of_accounts` (`id`, `account_code`, `account_name`, `class_id`, `parent_id`, `account_type`, `currency`, `current_balance`) VALUES
-- ASSETS (10000 - 19999)
(101, '10100', 'Cash on Hand - Main Office', 1, NULL, 'CASH', 'SAR', 45000.00),
(102, '10200', 'Petty Cash - Ops Pakistan', 1, NULL, 'CASH', 'PKR', 12000.00),
(103, '10300', 'Al-Rajhi Bank - Saudi Account', 1, NULL, 'BANK', 'SAR', 185000.00),
(104, '10400', 'Meezan Bank - Pakistan Account', 1, NULL, 'BANK', 'PKR', 320000.00),
(105, '11000', 'Accounts Receivable - Student Fees', 1, NULL, 'RECEIVABLE', 'SAR', 68500.00),
(106, '12000', 'Prepaid Software & Hosting', 1, NULL, 'PREPAID', 'SAR', 8500.00),
(107, '15100', 'Computers & IT Infrastructure', 1, NULL, 'FIXED_ASSET', 'SAR', 35000.00),
(108, '15200', 'Office Furniture & Equipment', 1, NULL, 'FIXED_ASSET', 'SAR', 15000.00),
(109, '15900', 'Accumulated Depreciation', 1, NULL, 'CONTRA_ASSET', 'SAR', -8500.00),

-- LIABILITIES (20000 - 29999)
(201, '20100', 'Accounts Payable - Vendors', 2, NULL, 'PAYABLE', 'SAR', 14200.00),
(202, '20200', 'Salaries Payable', 2, NULL, 'PAYABLE', 'SAR', 28000.00),
(203, '20300', 'Withholding Tax Payable', 2, NULL, 'PAYABLE', 'SAR', 3400.00),
(204, '21000', 'Deferred Tuition Revenue', 2, NULL, 'DEFERRED', 'SAR', 42000.00),

-- EQUITY (30000 - 39999)
(301, '30100', 'Owner Capital', 3, NULL, 'CAPITAL', 'SAR', 250000.00),
(302, '30200', 'Retained Earnings', 3, NULL, 'RETAINED_EARNINGS', 'SAR', 98700.00),
(303, '30300', 'Owner Drawings', 3, NULL, 'DRAWINGS', 'SAR', -15000.00),

-- REVENUE / INCOME (40000 - 49999)
(401, '40100', 'Tuition Fee Revenue', 4, NULL, 'REVENUE', 'SAR', 345000.00),
(402, '40200', 'Admission Fee Income', 4, NULL, 'REVENUE', 'SAR', 24000.00),
(403, '40300', 'Exam & Certificate Fee Income', 4, NULL, 'REVENUE', 'SAR', 12500.00),
(404, '40400', 'Books & Learning Material Income', 4, NULL, 'REVENUE', 'SAR', 18000.00),
(405, '40500', 'Late Fee & Fines Income', 4, NULL, 'REVENUE', 'SAR', 3200.00),

-- EXPENSES (50000 - 59999)
(501, '50100', 'Teachers & Staff Salaries', 5, NULL, 'EXPENSE', 'SAR', 145000.00),
(502, '50200', 'Software, LMS & Hosting Expense', 5, NULL, 'EXPENSE', 'SAR', 22000.00),
(503, '50300', 'Internet & Utilities', 5, NULL, 'EXPENSE', 'SAR', 9400.00),
(504, '50400', 'Marketing & Digital Ads', 5, NULL, 'EXPENSE', 'SAR', 31000.00),
(505, '50500', 'Office Rent & Maintenance', 5, NULL, 'EXPENSE', 'SAR', 18000.00),
(506, '50600', 'Bank Charges & Payment Gateway Fees', 5, NULL, 'EXPENSE', 'SAR', 4200.00),
(507, '50700', 'Depreciation Expense', 5, NULL, 'EXPENSE', 'SAR', 4500.00);";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:19:"brightbrai_newfajar";}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:{}__upload_status|a:1:{s:7:"handler";s:47:"PhpMyAdmin\Plugins\Import\Upload\UploadNoplugin";}Import_message|a:2:{s:7:"message";s:207:"<div class="alert alert-success" role="alert">
  <img src="themes/dot.gif" title="" alt="" class="icon ic_s_success"> <em>Import has been successfully finished, 47 queries executed.</em> (schema.sql)
</div>
";s:11:"go_back_url";s:55:"index.php?route=/database/import&db=brightbrai_newfajar";}is_multi_query|b:1;sql_history|a:2:{i:0;a:3:{s:2:"db";s:0:"";s:5:"table";s:0:"";s:8:"sqlquery";s:498:"-- =========================================================================================
-- ACADEMY ERP & ACCOUNTING MANAGEMENT SYSTEM
-- Normalized Enterprise Database DDL & Seed Data (MySQL 8 / Compatible)
-- Enterprise Double-Entry Accounting Core for New Fajar Academy (Saudi Arabia / Pakistan)
-- =========================================================================================

CREATE DATABASE IF NOT EXISTS `academy_erp` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";}i:1;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:0:"";s:8:"sqlquery";s:498:"-- =========================================================================================
-- ACADEMY ERP & ACCOUNTING MANAGEMENT SYSTEM
-- Normalized Enterprise Database DDL & Seed Data (MySQL 8 / Compatible)
-- Enterprise Double-Entry Accounting Core for New Fajar Academy (Saudi Arabia / Pakistan)
-- =========================================================================================

CREATE DATABASE IF NOT EXISTS `academy_erp` DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;";}}flashMessages|a:0:{}errors|a:0:{}

0xn0l - 0011000001111000011011100011000001101100