exec("CREATE TABLE IF NOT EXISTS administrators (
id INTEGER PRIMARY KEY AUTOINCREMENT,
login_id TEXT UNIQUE NOT NULL,
password_hash TEXT NOT NULL,
admin_name TEXT NOT NULL,
created_at DATETIME DEFAULT CURRENT_TIMESTAMP
)");
$login_id = 'admin';
$password = 'admin1234';
$admin_name = 'Admin';
$hash = password_hash($password, PASSWORD_DEFAULT);
$stmt = $db->prepare("SELECT id FROM administrators WHERE login_id = ?");
$stmt->execute([$login_id]);
if ($stmt->fetch()) {
$stmt = $db->prepare("UPDATE administrators SET password_hash = ?, admin_name = ? WHERE login_id = ?");
$stmt->execute([$hash, $admin_name, $login_id]);
echo "기존 admin 계정의 비밀번호를 admin1234로 초기화했습니다.
";
} else {
$stmt = $db->prepare("INSERT INTO administrators (login_id, password_hash, admin_name) VALUES (?, ?, ?)");
$stmt->execute([$login_id, $hash, $admin_name]);
echo "신규 admin 계정(PW: admin1234)을 생성했습니다.
";
}
echo "
로그인 페이지로 이동";
?>