<?php
$host = '127.0.0.1';
$db = 'nexcore_pharma';
$user = 'nexcore_pharma';
$pass = 'nexova@2026';

try {
    $pdo = new PDO("mysql:host=$host;dbname=$db;charset=utf8mb4", $user, $pass);
    $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
    $pdo->exec("ALTER TABLE tenants ADD COLUMN whatsapp_alerts JSON NULL");
    echo "Success\n";
} catch (PDOException $e) {
    echo $e->getMessage();
}
