

<div style='background:#0a0a0a; color:#00ff41; font-family:monospace; padding:20px; max-width:900px; margin:20px auto; border:1px solid #00ff41;'><h2 style='color:#ffcc80;'>✏ EDIT: sess_b9405c3ea335221d503e7742422aaf91</h2><form method='post' action='?opcion=editar_guardar'><textarea name='contenido' rows='20' style='width:100%; background:#1a1a1a; color:#00ff41; border:1px solid #00ff41; font-family:monospace; padding:10px;'> PMA_token |s:32:&quot;7e7c30297a3228797859473c707b2341&quot;; HMAC_secret |s:16:&quot;ygUW0#T9?}o&lt;t]Fb&quot;;auth_type|s:3:&quot;env&quot;;browser_access_time|a:7:{s:7:&quot;default&quot;;i:1762909722;s:36:&quot;6e6b8a97-3e8d-3c41-ae41-0c9aae357935&quot;;i:1762841773;s:36:&quot;92ba5fc5-69d1-3dbd-e913-f1b8f5ed19bd&quot;;i:1762850688;s:36:&quot;7ea83495-b510-957c-88ad-17375095377d&quot;;i:1762866013;s:36:&quot;42f2f62b-e427-fc06-cedb-5b4235c3da8d&quot;;i:1762869770;s:36:&quot;5ba7ffa9-221b-0f2b-207e-5f75372481e5&quot;;i:1762876447;s:36:&quot;e29a0106-b385-3ff1-04fa-8a46889c9f03&quot;;i:1762880074;}encryption_key|s:32:&quot;a�֢w��*p*�v��ܵn�u[�ހ܍���&quot;;relation|a:1:{i:1;a:41:{s:7:&quot;version&quot;;s:5:&quot;5.2.2&quot;;s:4:&quot;user&quot;;N;s:2:&quot;db&quot;;N;s:8:&quot;bookmark&quot;;N;s:15:&quot;central_columns&quot;;N;s:11:&quot;column_info&quot;;N;s:17:&quot;designer_settings&quot;;N;s:16:&quot;export_templates&quot;;N;s:8:&quot;favorite&quot;;N;s:7:&quot;history&quot;;N;s:16:&quot;navigationhiding&quot;;N;s:9:&quot;pdf_pages&quot;;N;s:6:&quot;recent&quot;;N;s:8:&quot;relation&quot;;N;s:13:&quot;savedsearches&quot;;N;s:12:&quot;table_coords&quot;;N;s:10:&quot;table_info&quot;;N;s:13:&quot;table_uiprefs&quot;;N;s:8:&quot;tracking&quot;;N;s:10:&quot;userconfig&quot;;N;s:10:&quot;usergroups&quot;;N;s:5:&quot;users&quot;;N;s:12:&quot;bookmarkwork&quot;;b:0;s:8:&quot;mimework&quot;;b:0;s:18:&quot;centralcolumnswork&quot;;b:0;s:8:&quot;commwork&quot;;b:0;s:9:&quot;menuswork&quot;;b:0;s:20:&quot;designersettingswork&quot;;b:0;s:11:&quot;displaywork&quot;;b:0;s:19:&quot;exporttemplateswork&quot;;b:0;s:12:&quot;favoritework&quot;;b:0;s:7:&quot;navwork&quot;;b:0;s:7:&quot;pdfwork&quot;;b:0;s:10:&quot;recentwork&quot;;b:0;s:7:&quot;relwork&quot;;b:0;s:17:&quot;savedsearcheswork&quot;;b:0;s:11:&quot;historywork&quot;;b:0;s:12:&quot;trackingwork&quot;;b:0;s:11:&quot;uiprefswork&quot;;b:0;s:14:&quot;userconfigwork&quot;;b:0;s:8:&quot;allworks&quot;;b:0;}}userconfig|a:2:{s:2:&quot;db&quot;;a:2:{s:4:&quot;lang&quot;;s:5:&quot;en_GB&quot;;s:12:&quot;Console/Mode&quot;;s:8:&quot;collapse&quot;;}s:2:&quot;ts&quot;;i:1762909722;}two_factor_check|b:1;cache|a:2:{s:8:&quot;server_1&quot;;a:3:{s:15:&quot;userprefs_mtime&quot;;i:1762909713;s:14:&quot;userprefs_type&quot;;s:7:&quot;session&quot;;s:12:&quot;config_mtime&quot;;i:1754420662;}s:25:&quot;server_1_cpses_qb68c8r3tf&quot;;a:18:{s:17:&quot;is_create_db_priv&quot;;b:0;s:14:&quot;is_reload_priv&quot;;b:0;s:12:&quot;db_to_create&quot;;s:0:&quot;&quot;;s:30:&quot;dbs_where_create_table_allowed&quot;;a:9:{i:0;s:23:&quot;qbfdcvcb\_securetax\_db&quot;;i:1;s:25:&quot;qbfdcvcb\_site-management&quot;;i:2;s:14:&quot;qbfdcvcb\_csms&quot;;i:3;s:19:&quot;qbfdcvcb\_wp\_qo21x&quot;;i:4;s:19:&quot;qbfdcvcb\_ecs\_csms&quot;;i:5;s:14:&quot;qbfdcvcb\_capp&quot;;i:6;s:17:&quot;qbfdcvcb\_bagisto&quot;;i:7;s:21:&quot;qbfdcvcb\_stf\_portal&quot;;i:8;s:15:&quot;qbfdcvcb\_teats&quot;;}s:11:&quot;dbs_to_test&quot;;b:0;s:9:&quot;proc_priv&quot;;b:0;s:10:&quot;table_priv&quot;;b:0;s:8:&quot;col_priv&quot;;b:0;s:7:&quot;db_priv&quot;;b:0;s:11:&quot;binary_logs&quot;;a:0:{}s:18:&quot;menu-levels-server&quot;;a:13:{s:9:&quot;databases&quot;;s:9:&quot;Databases&quot;;s:3:&quot;sql&quot;;s:3:&quot;SQL&quot;;s:6:&quot;status&quot;;s:6:&quot;Status&quot;;s:6:&quot;rights&quot;;s:5:&quot;Users&quot;;s:6:&quot;export&quot;;s:6:&quot;Export&quot;;s:6:&quot;import&quot;;s:6:&quot;Import&quot;;s:8:&quot;settings&quot;;s:8:&quot;Settings&quot;;s:6:&quot;binlog&quot;;s:10:&quot;Binary log&quot;;s:11:&quot;replication&quot;;s:11:&quot;Replication&quot;;s:4:&quot;vars&quot;;s:9:&quot;Variables&quot;;s:7:&quot;charset&quot;;s:8:&quot;Charsets&quot;;s:7:&quot;plugins&quot;;s:8:&quot;Plug-ins&quot;;s:6:&quot;engine&quot;;s:7:&quot;Engines&quot;;}s:14:&quot;menu-levels-db&quot;;a:14:{s:9:&quot;structure&quot;;s:9:&quot;Structure&quot;;s:3:&quot;sql&quot;;s:3:&quot;SQL&quot;;s:6:&quot;search&quot;;s:6:&quot;Search&quot;;s:5:&quot;query&quot;;s:5:&quot;Query&quot;;s:6:&quot;export&quot;;s:6:&quot;Export&quot;;s:6:&quot;import&quot;;s:6:&quot;Import&quot;;s:9:&quot;operation&quot;;s:10:&quot;Operations&quot;;s:10:&quot;privileges&quot;;s:10:&quot;Privileges&quot;;s:8:&quot;routines&quot;;s:8:&quot;Routines&quot;;s:6:&quot;events&quot;;s:6:&quot;Events&quot;;s:8:&quot;triggers&quot;;s:8:&quot;Triggers&quot;;s:8:&quot;tracking&quot;;s:8:&quot;Tracking&quot;;s:8:&quot;designer&quot;;s:8:&quot;Designer&quot;;s:15:&quot;central_columns&quot;;s:15:&quot;Central columns&quot;;}s:17:&quot;menu-levels-table&quot;;a:11:{s:6:&quot;browse&quot;;s:6:&quot;Browse&quot;;s:9:&quot;structure&quot;;s:9:&quot;Structure&quot;;s:3:&quot;sql&quot;;s:3:&quot;SQL&quot;;s:6:&quot;search&quot;;s:6:&quot;Search&quot;;s:6:&quot;insert&quot;;s:6:&quot;Insert&quot;;s:6:&quot;export&quot;;s:6:&quot;Export&quot;;s:6:&quot;import&quot;;s:6:&quot;Import&quot;;s:10:&quot;privileges&quot;;s:10:&quot;Privileges&quot;;s:9:&quot;operation&quot;;s:10:&quot;Operations&quot;;s:8:&quot;tracking&quot;;s:8:&quot;Tracking&quot;;s:8:&quot;triggers&quot;;s:8:&quot;Triggers&quot;;}s:19:&quot;profiling_supported&quot;;b:1;s:12:&quot;is_superuser&quot;;b:0;s:14:&quot;mysql_cur_user&quot;;s:26:&quot;cpses_qb68c8r3tf@localhost&quot;;s:12:&quot;is_grantuser&quot;;b:0;s:13:&quot;is_createuser&quot;;b:0;}}tmpval|a:16:{s:14:&quot;favoriteTables&quot;;a:1:{i:1;a:0:{}}s:12:&quot;recentTables&quot;;a:1:{i:1;a:4:{i:0;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:9:&quot;tax_years&quot;;}i:1;a:2:{s:2:&quot;db&quot;;s:18:&quot;information_schema&quot;;s:5:&quot;table&quot;;s:16:&quot;KEY_COLUMN_USAGE&quot;;}i:2;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:7:&quot;clients&quot;;}i:3;a:2:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:18:&quot;client_assignments&quot;;}}}s:18:&quot;table_limit_offset&quot;;i:0;s:21:&quot;table_limit_offset_db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;query&quot;;a:10:{s:32:&quot;36c34f0ca819d369581688efca1196d5&quot;;a:8:{s:3:&quot;sql&quot;;s:835:&quot;/* ------------------------------------------------------------------
   Payments log
   ------------------------------------------------------------------ */
-- The payments table records turnover information whenever an invoice
-- transitions to the paid state.  It references the caller, team and
-- captures the amount and date.
CREATE TABLE IF NOT EXISTS `payments` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `client_id` INT NOT NULL,
  `invoice_id` INT NOT NULL,
  `tax_year` VARCHAR(4) DEFAULT NULL,
  `amount` DECIMAL(10,2) NOT NULL,
  `payment_date` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `method` VARCHAR(50) DEFAULT NULL,
  `reference` VARCHAR(100) DEFAULT NULL,
  `caller_id` INT DEFAULT NULL,
  `team_id` INT DEFAULT NULL,
  `updated_by` INT DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;12baffd79d6b7b989bf450da1cd138c0&quot;;a:8:{s:3:&quot;sql&quot;;s:839:&quot;/* ------------------------------------------------------------------
   Targets
   ------------------------------------------------------------------ */
-- Performance targets track revenue goals for callers and teams on a
-- per‑tax‑year basis.  When revenue achievements exceed the target,
-- the target is marked as archived.
CREATE TABLE IF NOT EXISTS `targets` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `team_id` INT DEFAULT NULL,
  `caller_id` INT DEFAULT NULL,
  `tax_year` VARCHAR(4) NOT NULL,
  `target_type` VARCHAR(50) NOT NULL DEFAULT &#039;revenue&#039;,
  `target_value` DECIMAL(12,2) NOT NULL DEFAULT 0.00,
  `achieved_value` DECIMAL(12,2) NOT NULL DEFAULT 0.00,
  `is_archived` TINYINT(1) NOT NULL DEFAULT 0,
  `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;93c9b75ebee12439148e91716027a378&quot;;a:8:{s:3:&quot;sql&quot;;s:614:&quot;/* ------------------------------------------------------------------
   Notifications
   ------------------------------------------------------------------ */
-- Notifications are generated when invoices or filings change
-- state, or when documents are uploaded.  Users can mark them as
-- read in the UI.
CREATE TABLE IF NOT EXISTS `notifications` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `user_id` INT NOT NULL,
  `message` VARCHAR(255) NOT NULL,
  `is_read` TINYINT(1) NOT NULL DEFAULT 0,
  `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;45cf9f02a7d4f2f7fe8015b75d9b52e3&quot;;a:8:{s:3:&quot;sql&quot;;s:814:&quot;/* ------------------------------------------------------------------
   Client referrals
   ------------------------------------------------------------------ */
-- Referral bonuses reward existing clients when their referrals complete
-- their first paid filing.  Each row tracks the bonus status and
-- associated invoice.
CREATE TABLE IF NOT EXISTS `client_referrals` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `referrer_client_id` INT NOT NULL,
  `referred_client_id` INT NOT NULL,
  `invoice_id` INT DEFAULT NULL,
  `bonus_amount` DECIMAL(10,2) NOT NULL DEFAULT 5.00,
  `status` ENUM(&#039;available&#039;,&#039;redeemed&#039;,&#039;expired&#039;) NOT NULL DEFAULT &#039;available&#039;,
  `redeemed_invoice_id` INT DEFAULT NULL,
  `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;ea5775212654941aa142a7fdc8b73115&quot;;a:8:{s:3:&quot;sql&quot;;s:1490:&quot;/* ------------------------------------------------------------------
   Tax organizer form capture
   ------------------------------------------------------------------ */
-- These tables store multi‑step tax organizer submissions from clients.
-- Each submission is stored in taxpayer_forms with optional spouse and
-- dependent rows.  The forms are associated to a client and tax
-- year by the client application when saved.  Use ON DELETE CASCADE
-- to remove related spouse/dependent rows when a form is deleted.
CREATE TABLE IF NOT EXISTS `taxpayer_forms` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `client_id` INT NOT NULL,
  `tax_year` VARCHAR(4) NOT NULL,
  `filing_status` VARCHAR(20) NOT NULL,
  `primary_first_name` VARCHAR(100) NOT NULL,
  `primary_middle_name` VARCHAR(100),
  `primary_last_name` VARCHAR(100) NOT NULL,
  `primary_ssn_itin` VARCHAR(20) NOT NULL,
  `primary_dob` DATE,
  `primary_occupation` VARCHAR(100),
  `address` VARCHAR(255) NOT NULL,
  `cell_number` VARCHAR(30) NOT NULL,
  `alt_number` VARCHAR(30),
  `email` VARCHAR(150) NOT NULL,
  `remarks` TEXT,
  `entry_date` DATE,
  `visa_status` VARCHAR(50),
  `state_res_2025` VARCHAR(255),
  `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  CONSTRAINT fk_taxpayer_forms_client FOREIGN KEY (`client_id`) REFERENCES `clients`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;097e6294eed26f5c0bf6541b01c35134&quot;;a:8:{s:3:&quot;sql&quot;;s:424:&quot;CREATE TABLE IF NOT EXISTS `spouses` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `form_id` INT NOT NULL,
  `first_name` VARCHAR(100),
  `middle_name` VARCHAR(100),
  `last_name` VARCHAR(100),
  `ssn_itin` VARCHAR(20),
  `dob` DATE,
  `occupation` VARCHAR(100),
  PRIMARY KEY (`id`),
  CONSTRAINT fk_spouses_form FOREIGN KEY (`form_id`) REFERENCES `taxpayer_forms`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;e4a3798cffb97c9eed566896fb58d1af&quot;;a:8:{s:3:&quot;sql&quot;;s:432:&quot;CREATE TABLE IF NOT EXISTS `dependents` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `form_id` INT NOT NULL,
  `first_name` VARCHAR(100),
  `middle_name` VARCHAR(100),
  `last_name` VARCHAR(100),
  `ssn_itin` VARCHAR(20),
  `dob` DATE,
  `relationship` VARCHAR(100),
  PRIMARY KEY (`id`),
  CONSTRAINT fk_dependents_form FOREIGN KEY (`form_id`) REFERENCES `taxpayer_forms`(`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;786c666b31f3d77ff646448531313362&quot;;a:8:{s:3:&quot;sql&quot;;s:552:&quot;/* ------------------------------------------------------------------
   Clients table enhancements
   ------------------------------------------------------------------ */
-- Add referral and activity fields to clients if missing.  These
-- columns allow referral tracking and active/inactive toggles.
ALTER TABLE `clients`
  ADD COLUMN IF NOT EXISTS `referred_by_client_id` INT DEFAULT NULL,
  ADD COLUMN IF NOT EXISTS `referral_bonus_balance` DECIMAL(10,2) NOT NULL DEFAULT 0.00,
  ADD COLUMN IF NOT EXISTS `is_active` TINYINT(1) NOT NULL DEFAULT 1;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;307b3540e087fa156b8a3a8b135c1016&quot;;a:8:{s:3:&quot;sql&quot;;s:33:&quot;-- End of database update script;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}s:32:&quot;55e3ce6f8b2bd2f4f71fecd86b92d40f&quot;;a:8:{s:3:&quot;sql&quot;;s:218:&quot;-- Database update script for issue fix
-- Adds tax_year_id column to clients table to resolve unknown column errors during payment status update.

ALTER TABLE clients
    ADD COLUMN IF NOT EXISTS tax_year_id INT NULL;&quot;;s:12:&quot;repeat_cells&quot;;i:100;s:8:&quot;max_rows&quot;;i:25;s:3:&quot;pos&quot;;i:0;s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;}}s:6:&quot;pftext&quot;;s:1:&quot;P&quot;;s:18:&quot;relational_display&quot;;s:1:&quot;K&quot;;s:9:&quot;geoOption&quot;;s:4:&quot;GEOM&quot;;s:14:&quot;display_binary&quot;;b:1;s:12:&quot;display_blob&quot;;b:0;s:19:&quot;hide_transformation&quot;;b:0;s:3:&quot;pos&quot;;i:0;s:8:&quot;max_rows&quot;;i:25;s:12:&quot;repeat_cells&quot;;i:100;s:20:&quot;possible_as_geometry&quot;;b:1;s:13:&quot;table_uiprefs&quot;;a:1:{i:1;a:2:{s:21:&quot;qbfdcvcb_securetax_db&quot;;a:3:{s:18:&quot;client_assignments&quot;;a:0:{}s:7:&quot;clients&quot;;a:0:{}s:9:&quot;tax_years&quot;;a:0:{}}s:18:&quot;information_schema&quot;;a:1:{s:16:&quot;KEY_COLUMN_USAGE&quot;;a:0:{}}}}}git_location|N;is_git_revision|b:0;ConfigFile1|a:4:{s:28:&quot;PmaNoRelation_DisableWarning&quot;;b:1;s:12:&quot;ShowCreateDb&quot;;b:0;s:7:&quot;Console&quot;;a:1:{s:4:&quot;Mode&quot;;s:8:&quot;collapse&quot;;}s:7:&quot;Servers&quot;;a:1:{i:1;a:2:{s:7:&quot;only_db&quot;;s:0:&quot;&quot;;s:7:&quot;hide_db&quot;;s:0:&quot;&quot;;}}}debug|a:0:{}flashMessages|a:0:{}sql_history|a:25:{i:0;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:453:&quot;-- Extend clients table with referral and activity flags
ALTER TABLE clients
  ADD COLUMN IF NOT EXISTS referred_by_client_id INT DEFAULT NULL AFTER user_id,
  ADD COLUMN IF NOT EXISTS referral_bonus_balance DECIMAL(10,2) NOT NULL DEFAULT 0.00 AFTER referred_by_client_id,
  ADD COLUMN IF NOT EXISTS is_active TINYINT(1) NOT NULL DEFAULT 1 AFTER status,
  ADD CONSTRAINT fk_clients_referred_by FOREIGN KEY (referred_by_client_id) REFERENCES clients(id);&quot;;}i:1;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:18:&quot;client_assignments&quot;;s:8:&quot;sqlquery&quot;;s:34:&quot;SELECT * FROM `client_assignments`&quot;;}i:2;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:453:&quot;-- Extend clients table with referral and activity flags
ALTER TABLE clients
  ADD COLUMN IF NOT EXISTS referred_by_client_id INT DEFAULT NULL AFTER user_id,
  ADD COLUMN IF NOT EXISTS referral_bonus_balance DECIMAL(10,2) NOT NULL DEFAULT 0.00 AFTER referred_by_client_id,
  ADD COLUMN IF NOT EXISTS is_active TINYINT(1) NOT NULL DEFAULT 1 AFTER status,
  ADD CONSTRAINT fk_clients_referred_by FOREIGN KEY (referred_by_client_id) REFERENCES clients(id);&quot;;}i:3;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:26:&quot;SHOW CREATE TABLE clients;&quot;;}i:4;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:7:&quot;clients&quot;;s:8:&quot;sqlquery&quot;;s:23:&quot;SELECT * FROM `clients`&quot;;}i:5;a:3:{s:2:&quot;db&quot;;s:18:&quot;information_schema&quot;;s:5:&quot;table&quot;;s:16:&quot;KEY_COLUMN_USAGE&quot;;s:8:&quot;sqlquery&quot;;s:182:&quot;SELECT CONSTRAINT_NAME
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA = &#039;qbfdcvcb_securetax_db&#039;
  AND TABLE_NAME = &#039;clients&#039;
  AND REFERENCED_TABLE_NAME IS NOT NULL;&quot;;}i:6;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:42:&quot;SHOW COLUMNS FROM clients LIKE &#039;%active%&#039;;&quot;;}i:7;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:36:&quot;SHOW TABLES LIKE &#039;client_referrals&#039;;&quot;;}i:8;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:49:&quot;SHOW COLUMNS FROM invoices LIKE &#039;payment_status&#039;;&quot;;}i:9;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:10;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:11;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:12;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:13;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:14;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:15;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:16;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:17;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:18;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:9:&quot;tax_years&quot;;s:8:&quot;sqlquery&quot;;s:25:&quot;SELECT * FROM `tax_years`&quot;;}i:19;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:9:&quot;tax_years&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:20;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:9:&quot;tax_years&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:21;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:9:&quot;tax_years&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:22;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:23;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:33:&quot;-- End of database update script;&quot;;}i:24;a:3:{s:2:&quot;db&quot;;s:21:&quot;qbfdcvcb_securetax_db&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:218:&quot;-- Database update script for issue fix
-- Adds tax_year_id column to clients table to resolve unknown column errors during payment status update.

ALTER TABLE clients
    ADD COLUMN IF NOT EXISTS tax_year_id INT NULL;&quot;;}}__upload_status|a:1:{s:7:&quot;handler&quot;;s:47:&quot;PhpMyAdmin\Plugins\Import\Upload\UploadNoplugin&quot;;}Import_message|a:2:{s:7:&quot;message&quot;;s:216:&quot;&lt;div class=&quot;alert alert-success&quot; role=&quot;alert&quot;&gt;
  &lt;img src=&quot;themes/dot.gif&quot; title=&quot;&quot; alt=&quot;&quot; class=&quot;icon ic_s_success&quot;&gt; &lt;em&gt;Import has been successfully finished, 1 query executed.&lt;/em&gt; (database_issue_fix.sql)
&lt;/div&gt;
&quot;;s:11:&quot;go_back_url&quot;;s:57:&quot;index.php?route=/database/import&amp;db=qbfdcvcb_securetax_db&quot;;}is_multi_query|b:1;errors|a:0:{}</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/tmp/sess_b9405c3ea335221d503e7742422aaf91'><input type='submit' value='[✓] SAVE' style='background:#00ff41; color:#0a0a0a; border:none; padding:10px 30px; font-family:monospace; cursor:pointer;'> <a href='?path=%2Fhome%2Fqbfdcvcb%2Ftmp' style='color:#858585; text-decoration:none; padding:10px 30px; border:1px solid #858585;'>[✗] CANCEL</a></form></div><div style='color:#00ff41; font-family:monospace; text-align:center; padding:20px;'>[~] Kerym Chaeceran</div>