<?php

return function (PDO $pdo): void {
    $roles = [
        [142345678901234561, 'Administrator', 'admin'],
        [142345678901234564, 'User', 'user'],
        [142345678901234569, 'Service', 'service'],
    ];

    $stmt = $pdo->prepare('INSERT IGNORE INTO auth_roles (id, name, slug) VALUES (:id, :name, :slug)');
    foreach ($roles as $role) {
        $stmt->execute(['id' => $role[0], 'name' => $role[1], 'slug' => $role[2]]);
    }

    $statuses = [
        [142345678901234591, 'Active', 'active'],
        [142345678901234592, 'Pending Verification', 'pending-verification'],
        [142345678901234593, 'Suspended', 'suspended'],
        [142345678901234594, 'Banned', 'banned'],
        [142345678901234595, 'Inactive / Deactivated', 'inactive'],
        [142345678901234596, 'Archived', 'archived'],
    ];

    $stmt = $pdo->prepare('INSERT IGNORE INTO auth_statuses (id, name, slug) VALUES (:id, :name, :slug)');
    foreach ($statuses as $status) {
        $stmt->execute(['id' => $status[0], 'name' => $status[1], 'slug' => $status[2]]);
    }
};
