0xn0l

📂 /home/brightbrai/tmp

✎ EDIT: sess_a8a0598b3742fa7c6953adccf8580c62 ← BACK

PMA_token |s:32:"3c2c50622e3b67415762392a346e617e"; HMAC_secret |s:16:"U{yh=qbqJIIuU4=W";auth_type|s:3:"env";browser_access_time|a:1:{s:7:"default";i:1785411771;}encryption_key|s:32:"�|ZpjU�q&f��#�$(	���	bAAخv�";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:1785410263;}two_factor_check|b:1;cache|a:2:{s:8:"server_1";a:4:{s:15:"userprefs_mtime";i:1785410263;s:14:"userprefs_type";s:7:"session";s:12:"config_mtime";i:1778012714;s:9:"userprefs";a:1:{s:7:"Console";a:1:{s:4:"Mode";s:8:"collapse";}}}s:19:"server_1_brightbrai";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:38:{i:0;s:14:"brightbrai\_CM";i:1;s:16:"brightbrai\_spps";i:2;s:22:"brightbrai\_darsequran";i:3;s:17:"brightbrai\_sindh";i:4;s:17:"brightbrai\_wp384";i:5;s:18:"brightbrai\_income";i:6;s:17:"brightbrai\_wp876";i:7;s:19:"brightbrai\_newmart";i:8;s:17:"brightbrai\_emart";i:9;s:21:"brightbrai\_academydb";i:10;s:22:"brightbrai\_abdulmalik";i:11;s:17:"brightbrai\_wp272";i:12;s:19:"brightbrai\_student";i:13;s:18:"brightbrai\_newsmc";i:14;s:19:"brightbrai\_wp66409";i:15;s:18:"brightbrai\_emart2";i:16;s:17:"brightbrai\_smart";i:17;s:27:"brightbrai\_instagram.login";i:18;s:25:"brightbrai\_sorbitacademy";i:19;s:20:"brightbrai\_contacts";i:20;s:17:"brightbrai\_wp347";i:21;s:14:"brightbrai\_ss";i:22;s:17:"brightbrai\_store";i:23;s:18:"brightbrai\_school";i:24;s:20:"brightbrai\_newfajar";i:25;s:19:"brightbrai\_academy";i:26;s:18:"brightbrai\_sas123";i:27;s:20:"brightbrai\_hospital";i:28;s:16:"brightbrai\_SMCS";i:29;s:16:"brightbrai\_SMSS";i:30;s:20:"brightbrai\_students";i:31;s:25:"brightbrai\_SchoolProject";i:32;s:27:"brightbrai\_brightbrai\_SMS";i:33;s:16:"brightbrai\_test";i:34;s:23:"brightbrai\_electronics";i:35;s:15:"brightbrai\_SMS";i:36;s:19:"brightbrai\_sample1";i:37;s:19:"brightbrai\_expense";}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: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:"brightbrai@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:4:{i:0;a:2:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:10:"audit_logs";}i:1;a:2:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:15:"account_classes";}i:2;a:2:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:18:"accounting_periods";}i:3;a:2:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:8:"students";}}}s:18:"table_limit_offset";i:0;s:21:"table_limit_offset_db";s:19:"brightbrai_newfajar";s:13:"table_uiprefs";a:1:{i:1;a:1:{s:19:"brightbrai_newfajar";a:4:{s:8:"students";a:0:{}s:18:"accounting_periods";a:0:{}s:15:"account_classes";a:0:{}s:10:"audit_logs";a:0:{}}}}s:5:"query";a:10:{s:32:"4b473979017b0b1779b939cf313be3e2";a:8:{s:3:"sql";s:363:"-- 1. Ensure Courses & Employees Tables Exist
CREATE TABLE IF NOT EXISTS `courses` (
  `id` INT AUTO_INCREMENT PRIMARY KEY,
  `class_level` VARCHAR(50) NOT NULL,
  `course_name` VARCHAR(100) NOT NULL,
  `created_at` TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  UNIQUE KEY `idx_class_course` (`class_level`, `course_name`)
) 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:"2ea2679a79b8094c5c311c3e8aaf6acd";a:8:{s:3:"sql";s:572:"CREATE TABLE IF NOT EXISTS `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 NULL DEFAULT NULL,
  `basic_salary` DECIMAL(12,2) DEFAULT 0.00,
  `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:"e5445ca7f2db6def4d19221d6f03ee1e";a:8:{s:3:"sql";s:4013:"-- 2. Populate All 8 Expat Students (Includes passport_number)
INSERT INTO `students` 
(`student_number`, `registration_number`, `first_name`, `last_name`, `gender`, `dob`, `nationality`, `address`, `guardian_name`, `guardian_phone`, `guardian_email`, `course_name`, `class_level`, `section`, `batch_year`, `custom_tuition_fee`, `fee_due_date`, `status`, `admission_date`, `photo_url`, `passport_number`)
VALUES 
('NFA-2025-001', 'REG-98401', 'Muhammad', 'Ali', 'MALE', '2012-05-14', 'Pakistani', 'Building 14, Olaya Street, Riyadh, Saudi Arabia', 'Tariq Ali', '+966 50 123 4567', 'tariq.ali@gmail.com', 'IGCSE O-Level Mathematics & Science', 'Grade 9', 'A', '2025-2026', 1800.00, '10th of every month', 'ACTIVE', '2025-07-01', 'https://images.unsplash.com/photo-1544717305-2782549b5136?auto=format&fit=crop&q=80&w=200', 'PK9482019'),
('NFA-2025-002', 'REG-98402', 'Fatima', 'Zahra', 'FEMALE', '2011-09-20', 'Pakistani', 'Al-Safa District, Street 8, Jeddah, Saudi Arabia', 'Dr. Usman Ahmed', '+966 55 987 6543', 'usman.ahmed@yahoo.com', 'FBISE Grade 10 Matriculation', 'Grade 10', 'B', '2025-2026', 1200.00, '5th of every month', 'ACTIVE', '2025-07-05', 'https://images.unsplash.com/photo-1517841905240-472988babdf9?auto=format&fit=crop&q=80&w=200', 'PK8291034'),
('NFA-2025-003', 'REG-98403', 'Ayan', 'Khan', 'MALE', '2014-01-11', 'Pakistani', 'House #42, Main Commercial Market, Islamabad, Pakistan', 'Shahid Khan', '+92 300 555 4433', 'shahid.khan@hotmail.com', 'Primary Islamic Studies & English', 'Grade 6', 'A', '2025-2026', 950.00, '1st of every month', 'ACTIVE', '2025-07-10', 'https://images.unsplash.com/photo-1539571696357-5a69c17a67c6?auto=format&fit=crop&q=80&w=200', 'PK7492011'),
('NFA-2025-004', 'REG-98404', 'Bilal', 'Ahmed', 'MALE', '2010-03-22', 'Pakistani', 'King Fahd Road, Suite 402, Dammam, Saudi Arabia', 'Zubair Ahmed', '+966 54 321 0987', 'zubair.ahmed@gmail.com', 'A-Level Mathematics & Physics', 'Grade 11', 'A', '2025-2026', 2200.00, '10th of every month', 'ACTIVE', '2025-08-01', 'https://images.unsplash.com/photo-1507003211169-0a1dd7228f2d?auto=format&fit=crop&q=80&w=200', 'PK6583920'),
('NFA-2025-005', 'REG-98405', 'Sara', 'Mahmood', 'FEMALE', '2011-11-05', 'Pakistani', 'Al-Nakheel District, Villa 12, Riyadh, Saudi Arabia', 'Mahmood Hassan', '+966 56 112 2334', 'mahmood.hassan@outlook.com', 'O-Level Biology & Computer Science', 'Grade 10', 'A', '2025-2026', 2500.00, '5th of every month', 'ACTIVE', '2025-08-15', 'https://images.unsplash.com/photo-1494790108377-be9c29b29330?auto=format&fit=crop&q=80&w=200', 'PK5472819'),
('NFA-2025-006', 'REG-98406', 'Zainab', 'Hameed', 'FEMALE', '2009-06-18', 'Pakistani', 'Sector F-7/2, Street 15, Islamabad, Pakistan', 'Abdul Hameed', '+92 321 888 7766', 'abdul.hameed@gmail.com', 'FSc Pre-Medical / Pre-Engineering', 'Grade 12', 'A', '2025-2026', 2000.00, '1st of every month', 'ACTIVE', '2025-09-01', 'https://images.unsplash.com/photo-1534528741775-53994a69daeb?auto=format&fit=crop&q=80&w=200', 'PK4361708'),
('NFA-2025-007', 'REG-98407', 'Ibrahim', 'Khalil', 'MALE', '2013-02-14', 'Pakistani', 'Corniche Area, Dammam, Saudi Arabia', 'Khalil Ur Rehman', '+966 54 111 2222', 'khalil@gmail.com', 'A-Level Mathematics', 'Grade 11', 'A', '2025-2026', 2100.00, '10th of every month', 'ACTIVE', '2025-09-15', 'https://images.unsplash.com/photo-1500648767791-00dcc994a43e?auto=format&fit=crop&q=80&w=200', 'PK3250697'),
('NFA-2025-008', 'REG-98408', 'Usman', 'Ghani', 'MALE', '2015-04-10', 'Pakistani', 'Al-Khobar Shamalia, Saudi Arabia', 'Ghani Khan', '+966 55 222 3333', 'ghani@gmail.com', 'Primary Science', 'Grade 4', 'A', '2025-2026', 1100.00, '10th of every month', 'ACTIVE', '2025-10-01', 'https://images.unsplash.com/photo-1506794778202-cad84cf45f1d?auto=format&fit=crop&q=80&w=200', 'PK2149586')
ON DUPLICATE KEY UPDATE 
first_name=VALUES(first_name), 
last_name=VALUES(last_name),
custom_tuition_fee=VALUES(custom_tuition_fee),
course_name=VALUES(course_name),
class_level=VALUES(class_level),
status='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:"bc34d2eb598fb000ccb78d27f8b22cff";a:8:{s:3:"sql";s:535:"-- 3. Populate Courses
INSERT INTO `courses` (`class_level`, `course_name`) VALUES 
('Grade 9', 'IGCSE O-Level Mathematics & Science'),
('Grade 9', 'IGCSE Physics & Chemistry'),
('Grade 10', 'FBISE Grade 10 Matriculation'),
('Grade 10', 'O-Level Biology & Computer Science'),
('Grade 6', 'Primary Islamic Studies & English'),
('Grade 6', 'General Science & Mathematics'),
('Grade 11', 'A-Level Mathematics & Physics'),
('Grade 12', 'FSc Pre-Medical / Pre-Engineering')
ON DUPLICATE KEY UPDATE course_name=VALUES(course_name);";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:"0519ddbf69a22a3195d80b1f7bf2db02";a:8:{s:3:"sql";s:776:"-- 4. Populate Employees
INSERT INTO `employees` (`id`, `employee_code`, `name`, `designation`, `department`, `join_date`, `basic_salary`, `allowances`, `tax_deduction`, `status`) VALUES
(1, 'EMP-001', 'Dr. Tariq Mahmood', 'Senior Mathematics Faculty', 'Academics', '2025-07-01', 85000.00, 15000.00, 3000.00, 'ACTIVE'),
(2, 'EMP-002', 'Ayesha Siddiqui', 'Physics & Chemistry Lecturer', 'Academics', '2025-07-01', 72000.00, 12000.00, 2400.00, 'ACTIVE'),
(3, 'EMP-003', 'Usman Ali', 'IT LMS & Infrastructure Admin', 'Operations PK', '2025-07-01', 45000.00, 8000.00, 1500.00, 'ACTIVE'),
(4, 'EMP-004', 'Mariam Khan', 'Academic Coordinator & Student Counselor', 'Administration', '2025-07-01', 60000.00, 9000.00, 1800.00, 'ACTIVE')
ON DUPLICATE KEY UPDATE name=VALUES(name);";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:"41592cd5e2bdd30dd58397030deb9614";a:8:{s:3:"sql";s:24:"SELECT * FROM `students`";s:12:"repeat_cells";i:100;s:8:"max_rows";s:3:"all";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:"c48d83495dc09ea133446eca2ce79edb";a:8:{s:3:"sql";s:34:"SELECT * FROM `accounting_periods`";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:"222d3f307a133e428197b1ba0a27a198";a:8:{s:3:"sql";s:31:"SELECT * FROM `account_classes`";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:"762524e88866cf84597829326aadc77a";a:8:{s:3:"sql";s:26:"SELECT * FROM `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: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:20:"possible_as_geometry";b:1;}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:{}is_multi_query|b:0;sql_history|a:14:{i:0;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:8:"students";s:8:"sqlquery";s:24:"SELECT * FROM `students`";}i:1;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:8:"students";s:8:"sqlquery";s:24:"SELECT * FROM `students`";}i:2;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:8:"students";s:8:"sqlquery";s:24:"SELECT * FROM `students`";}i:3;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:8:"students";s:8:"sqlquery";s:24:"SELECT * FROM `students`";}i:4;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:8:"students";s:8:"sqlquery";s:24:"SELECT * FROM `students`";}i:5;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:8:"students";s:8:"sqlquery";s:24:"SELECT * FROM `students`";}i:6;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:8:"students";s:8:"sqlquery";s:24:"SELECT * FROM `students`";}i:7;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:8:"students";s:8:"sqlquery";s:24:"SELECT * FROM `students`";}i:8;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:8:"students";s:8:"sqlquery";s:27:"SET FOREIGN_KEY_CHECKS = 1;";}i:9;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:8:"students";s:8:"sqlquery";s:24:"SELECT * FROM `students`";}i:10;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:8:"students";s:8:"sqlquery";s:24:"SELECT * FROM `students`";}i:11;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:18:"accounting_periods";s:8:"sqlquery";s:34:"SELECT * FROM `accounting_periods`";}i:12;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:15:"account_classes";s:8:"sqlquery";s:31:"SELECT * FROM `account_classes`";}i:13;a:3:{s:2:"db";s:19:"brightbrai_newfajar";s:5:"table";s:10:"audit_logs";s:8:"sqlquery";s:26:"SELECT * FROM `audit_logs`";}}Import_message|a:2:{s:7:"message";N;s:11:"go_back_url";s:70:"index.php?route=/table/structure&db=brightbrai_newfajar&table=students";}errors|a:0:{}

0xn0l - 0011000001111000011011100011000001101100