18 lines
661 B
PHP
18 lines
661 B
PHP
<?php
|
|
require_once __DIR__ . '/../../db/config.php';
|
|
|
|
try {
|
|
$conn = db();
|
|
$sql = "ALTER TABLE users ADD COLUMN role VARCHAR(255) NOT NULL DEFAULT 'user'";
|
|
$conn->exec($sql);
|
|
// Set user with id 1 to be an admin
|
|
$sql_admin = "UPDATE users SET role = 'admin' WHERE id = 1";
|
|
$conn->exec($sql_admin);
|
|
// Set user with id 2 to be a manager
|
|
$sql_manager = "UPDATE users SET role = 'manager' WHERE id = 2";
|
|
$conn->exec($sql_manager);
|
|
echo "Migration successful: 'role' column added to 'users' table and default users updated." . PHP_EOL;
|
|
} catch (PDOException $e) {
|
|
echo "Migration failed: " . $e->getMessage() . PHP_EOL;
|
|
}
|