<?php
$dsn = "mysql:host=127.0.0.1;dbname=ibvte;charset=utf8mb4";
$pdo = new PDO($dsn, 'root', '', [PDO::ATTR_ERRMODE => PDO::ERRMODE_EXCEPTION]);

try { $pdo->exec("ALTER TABLE notifications ADD COLUMN image_path VARCHAR(255)"); } catch(Exception $e) {}
try { $pdo->exec("ALTER TABLE notifications ADD COLUMN pdf_path VARCHAR(255)"); } catch(Exception $e) {}
try { $pdo->exec("ALTER TABLE notifications ADD COLUMN is_marquee TINYINT(1) DEFAULT 0"); } catch(Exception $e) {}
try { $pdo->exec("ALTER TABLE notifications ADD COLUMN status ENUM('active', 'inactive') DEFAULT 'active'"); } catch(Exception $e) {}

echo "Altered.\n";
