14 lines
372 B
PHP
14 lines
372 B
PHP
<?php
|
|
require_once __DIR__ . '/../config.php';
|
|
$pdo = db();
|
|
|
|
try {
|
|
$pdo->exec("
|
|
ALTER TABLE truck_owner_profiles
|
|
ADD COLUMN IF NOT EXISTS ctr_number VARCHAR(100) DEFAULT NULL,
|
|
ADD COLUMN IF NOT EXISTS notes TEXT DEFAULT NULL;
|
|
");
|
|
echo "Schema updated successfully.";
|
|
} catch (PDOException $e) {
|
|
echo "Error: " . $e->getMessage();
|
|
} |