setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // Create responsables table $sql = <<exec($sql); echo "Table 'responsables' created successfully.
"; // Create actividades table $sql = <<exec($sql); echo "Table 'actividades' created successfully.
"; // Create users table $sql = <<exec($sql); echo "Table 'users' created successfully.
"; // Insert admin user if not exists $stmt = $pdo->prepare("SELECT id FROM users WHERE username = 'admin'"); $stmt->execute(); if ($stmt->fetch()) { echo "User 'admin' already exists.
"; } else { $adminPassword = password_hash('admin', PASSWORD_DEFAULT); $sql = "INSERT INTO `users` (`username`, `password_hash`, `role`) VALUES ('admin', :password, 'administrador')"; $stmt = $pdo->prepare($sql); $stmt->bindParam(':password', $adminPassword); $stmt->execute(); echo "User 'admin' created successfully.
"; } } catch (PDOException $e) { die("DB ERROR: " . $e->getMessage()); }