14 lines
483 B
PHP
14 lines
483 B
PHP
<?php
|
|
require_once __DIR__ . '/../config.php';
|
|
|
|
try {
|
|
echo "Adding 'pending_approval' to shipments status enum...\n";
|
|
// MariaDB/MySQL ALTER TABLE to modify column
|
|
$sql = "ALTER TABLE shipments MODIFY COLUMN status ENUM('pending_approval', 'posted','offered','confirmed','in_transit','delivered') NOT NULL DEFAULT 'posted'";
|
|
db()->exec($sql);
|
|
echo "Migration successful.\n";
|
|
} catch (PDOException $e) {
|
|
echo "Migration failed: " . $e->getMessage() . "\n";
|
|
}
|
|
|