getConnection(); if (!$db) { die('Database connection failed'); } echo " Update IoT Devices Table

🔧 Updating iot_devices Table

"; // Check current structure echo "

Current Table Structure

"; $columns = $db->query("SHOW COLUMNS FROM iot_devices")->fetchAll(PDO::FETCH_ASSOC); $existing_columns = array_column($columns, 'Field'); echo "

Existing columns: " . implode(', ', $existing_columns) . "

"; echo "

"; // Add missing columns $columns_to_add = [ 'is_active' => "ALTER TABLE iot_devices ADD COLUMN is_active BOOLEAN DEFAULT TRUE AFTER is_online", 'ip_address' => "ALTER TABLE iot_devices ADD COLUMN ip_address VARCHAR(45) AFTER last_seen", 'firmware_version' => "ALTER TABLE iot_devices ADD COLUMN firmware_version VARCHAR(20) AFTER ip_address" ]; echo "

Adding Missing Columns

"; foreach ($columns_to_add as $column => $sql) { if (!in_array($column, $existing_columns)) { try { $db->exec($sql); echo "

✅ Added column: {$column}

"; } catch (Exception $e) { echo "

❌ Error adding {$column}: " . htmlspecialchars($e->getMessage()) . "

"; } } else { echo "

ℹ️ Column {$column} already exists

"; } } echo "

"; // Verify final structure echo "

📋 Final Structure

"; $columns = $db->query("SHOW COLUMNS FROM iot_devices")->fetchAll(PDO::FETCH_ASSOC); echo ""; echo ""; foreach ($columns as $col) { echo ""; echo ""; echo ""; echo ""; echo ""; } echo "

Column	Type	Default
" . htmlspecialchars($col['Field']) . "	" . htmlspecialchars($col['Type']) . "	" . htmlspecialchars($col['Default'] ?? 'NULL') . "

"; echo "

🎉 Table Updated Successfully!

Now let's create the missing tables...

➡️ Create Missing Tables

"; echo ""; } catch (Exception $e) { echo "

❌ Fatal Error: " . htmlspecialchars($e->getMessage()) . "

"; } ?>