43 lines
1.4 KiB
PHP
43 lines
1.4 KiB
PHP
<?php
|
|
require_once __DIR__ . '/config.php';
|
|
|
|
try {
|
|
$pdo = db();
|
|
// Drop and recreate table
|
|
$sql = file_get_contents(__DIR__ . '/migrations/001_create_users_table.sql');
|
|
$pdo->exec($sql);
|
|
echo "Table 'users' created successfully.\n";
|
|
|
|
// New users
|
|
$users = [
|
|
['Admin', 'admin', 'password123', 'Admin'],
|
|
['Rumaiz', 'rumaiz', 'Rumaiz4556', 'Manager'],
|
|
['Nadeeni', 'nadeeni', 'Nadz1234', 'Manager'],
|
|
['Kaveesh', 'kaveesh', 'Kaveesh123', 'Staff'],
|
|
['Sarani', 'sarani', 'Sarani789', 'Staff'],
|
|
['Nazeeha', 'nazeeha', 'Nazeeha1234', 'Staff'],
|
|
['Thiwanka', 'thiwanka', 'Thiwanka567', 'Staff'],
|
|
['Customer Service', 'customerservice', 'Coho2646', 'Staff'],
|
|
['Siranjeewan', 'siranjeewan', 'Siranjeewan123', 'Rider'],
|
|
['Rozan', 'rozan', 'Rozan123', 'Rider'],
|
|
['Coho Rider', 'cohorider', 'Coho123456', 'Rider'],
|
|
];
|
|
|
|
$stmt = $pdo->prepare(
|
|
'INSERT INTO users (full_name, username, password, role) VALUES (?, ?, ?, ?)'
|
|
);
|
|
|
|
foreach ($users as $user) {
|
|
$fullName = $user[0];
|
|
$username = $user[1];
|
|
$password = password_hash($user[2], PASSWORD_DEFAULT);
|
|
$role = $user[3];
|
|
$stmt->execute([$fullName, $username, $password, $role]);
|
|
}
|
|
|
|
echo "Users inserted successfully.\n";
|
|
echo "Migration completed successfully.\n";
|
|
|
|
} catch (PDOException $e) {
|
|
die("Migration failed: " . $e->getMessage() . "\n");
|
|
} |